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]

Re: st: Want to load only part of ASCII file


From   Jeph Herrin <stata@spandrel.net>
To   statalist@hsphsun2.harvard.edu
Subject   Re: st: Want to load only part of ASCII file
Date   Wed, 21 Jul 2010 09:27:53 -0400

Sometimes the best solution isn't a Stata solution; for this kind of
problem I usually invoke some other software. For instance,
Stat/Transfer will convert a .csv file to a Stata file while retaining
only selected variables, and does not require vast RAM. Or, you can
open in Excel, delete a few columns, and save as a new .csv file;
Excel also buffers to disk and hence needs less RAM. (If you go the
Excel route, though, be exceedingly careful, because Excel makes it
too easy to corrupt your data  - for instance, by sorting a single
column.)

hth,
Jeph


On 7/20/2010 7:38 PM, enewton@notes.cc.sunysb.edu wrote:
Hi,

I'm new to Stata, and new to this listserv. I'd like to load a very
large ASCII .csv file into a .dta Stata file but it keeps bumping up
against the 1.1g memory limit and Stata suggests I "drop some
observations or variables." My question is how one can load just a
portion of an ASCII file--for example, the specific variables of
interest, or only those observations where variable1=xyz--so as to
end up with a more manageable Stata file.

A second question is why I can't set memory higher than about 1.3g,
when I have about 100g of space left on the computer, but that's
probably something my computer&  I need to work out between
ourselves.

Thanks.

* *   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/

*
*   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