Bookmark and Share

Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

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

From   Maarten Buis <>
Subject   Re: st: Can I open a database almost larger than my RAM memory?
Date   Wed, 29 Aug 2012 09:11:26 +0200

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: )

Hope this helps,

Maarten L. Buis
Reichpietschufer 50
10785 Berlin

*   For searches and help try:

© Copyright 1996–2018 StataCorp LLC   |   Terms of use   |   Privacy   |   Contact us   |   Site index