Bookmark and Share

Notice: On March 31, it was announced that Statalist is moving from an email list to a forum. The old list will shut down at the end of May, and its replacement, statalist.org is already up and running.


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

st: file too big to import


From   "King, Carina" <c.king09@imperial.ac.uk>
To   "statalist@hsphsun2.harvard.edu" <statalist@hsphsun2.harvard.edu>
Subject   st: file too big to import
Date   Wed, 20 Apr 2011 11:57:44 +0100

Hi,

I am having problems importing a file. It is stored as csv file and contains (I think, as I haven't been able to see the full data yet) over 1,400,000 records with 25 variables. So far I have tried the following:

Opening it with insheet using "D:\datasets\mr_final.csv" (not enough memory), so and I increased my memory (which is now set to 10,000) and it's still not enough. 

I tried opening it in excel and wordpad so I could separate it out into smaller chunks, but it crashes the programmes when I try that. 

I attempted to use infile and specify "in 1/500000" but it comes with the error message 'file does not contain dictionary'

So, is there a way to make a dictionary? Or change the file type so it takes less space? Or use the 'in' option with insheet? Or any other ideas?? I'm totally stuck! Thanks!

Kind Regards,
Carina


*
*   For searches and help try:
*   http://www.stata.com/help.cgi?search
*   http://www.stata.com/support/statalist/faq
*   http://www.ats.ucla.edu/stat/stata/


© Copyright 1996–2014 StataCorp LP   |   Terms of use   |   Privacy   |   Contact us   |   Site index