Re: st: Can I open a database almost larger than my RAM memory?

[Maarten Buis <maartenlbuis@gmail.com>]

On Wed, Aug 29, 2012 at 2:54 AM, André Klafke wrote:
> I have a 3.2 GB database and my notebook is a Samsung RV411, processor
> Intel(R) Core(TM) i5 CPU M480 @2.67 GHz, system 64 bits, RAM 4GB, OS Windows
> 7.
>
> Can I configure my Stata/SE 9.0 for Windows to open such database? How can I
> do it?

Often you don't want all variables in such a large dataset. In that
case you can extract and open only those variables you want without
opening the entire dataset. For such situations it is often useful
that you can also -describe- the variables within a dataset without
opening it (e.g. to get the exact variable names). See the example
below and -help use- and -help describe-.

*----------- begin example -------------
// move to directory where the
// auto.dta dataset is stored
cd `c(sysdir_base)'/a

// describe the variables without
// opening the auto.dta dataset
desc using auto.dta

// we decide we only want price and mpg
use price mpg using auto.dta
*----------- begin example -------------
(For more on examples I sent to the Statalist see:
http://www.maartenbuis.nl/example_faq )

Hope this helps,
Maarten

---------------------------------
Maarten L. Buis
WZB
Reichpietschufer 50
10785 Berlin
Germany

http://www.maartenbuis.nl
---------------------------------

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