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 on April 23, 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   Kay Walker <kay.walker@internode.on.net>
To   statalist@hsphsun2.harvard.edu
Subject   Re: st: Want to load only part of ASCII file
Date   Wed, 21 Jul 2010 11:03:36 +0930

Why not just import it all and then delete the unwanted columns? It's certainly quick if you have the memory available!

Eric Booth wrote:
<>


Additionally, if your .csv file is already formatted in a way that you can insheet it, you could specify the varlist to insheet (see -help insheet-).

Sorry, that part is incorrect.  While this works with selecting some variables using the -use- command, it doesn't work for -insheet- in the same way--I got these two confused.  (The varlist in -insheet- expects you to specify the names of all the variables, not a subset to be loaded)

~ Eric


__
Eric A. Booth
Public Policy Research Institute
Texas A&M University
ebooth@ppri.tamu.edu
Office: +979.845.6754


On Jul 20, 2010, at 7:21 PM,  wrote:

<>

Scott Merryman wrote:
You might want to try David Elliott's -chunky- or Roy Wada's
-chewfile-.  Use -findit chunky- or -findit chewfile- to locate and
download.

Scott

Additionally, if your .csv file is already formatted in a way that you can insheet it, you could specify the varlist to insheet (see -help insheet-).



enewton wrote:
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.
Physical memory (or RAM) is different from hard drive capacity.  See these for more on your issue:
http://www.stata.com/support/faqs/win/pcreqs.html
http://www.stata.com/statalist/archive/2010-01/msg00369.html


~ Eric
__
Eric A. Booth
Public Policy Research Institute
Texas A&M University
ebooth@ppri.tamu.edu
Office: +979.845.6754
Fax: +979.845.0249
http://ppri.tamu.edu



On Tue, Jul 20, 2010 at 6: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