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

[Kay Walker <kay.walker@internode.on.net>]

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/