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]

From |
Jon Gettman <jgettman@hughes.net> |

To |
statalist@hsphsun2.harvard.edu |

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

Date |
Wed, 21 Jul 2010 10:45:03 -0400 |

Jon Gettman At 09:27 AM 7/21/2010, you wrote:

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/

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

**Follow-Ups**:**RE: st: Want to load only part of ASCII file***From:*"Lachenbruch, Peter" <Peter.Lachenbruch@oregonstate.edu>

**References**:**st: Want to load only part of ASCII file***From:*enewton@notes.cc.sunysb.edu

**Re: st: Want to load only part of ASCII file***From:*Jeph Herrin <stata@spandrel.net>

- Prev by Date:
**st: Unbalanced repeated measures analysis question** - Next by Date:
**RE: AW: st: bootstrap _b VS bootstrap _se** - Previous by thread:
**Re: st: Want to load only part of ASCII file** - Next by thread:
**RE: st: Want to load only part of ASCII file** - Index(es):