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]

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


From   André Klafke <andreklafke@hotmail.com>
To   <statalist@hsphsun2.harvard.edu>
Subject   st: Re: Can I open a database almost larger than my RAM memory?
Date   Wed, 29 Aug 2012 17:15:46 -0300

Thank you, Maarten,

It helped!

Best regards,
André
Brazil

-----Mensagem Original----- From: Maarten Buis
Sent: Wednesday, August 29, 2012 4:11 AM
To: statalist@hsphsun2.harvard.edu
Subject: Re: st: Can I open a database almost larger than my RAM memory?

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