Stata The Stata listserver
[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]

st: Re: data size


From   Friedrich Huebler <huebler@rocketmail.com>
To   statalist@hsphsun2.harvard.edu
Subject   st: Re: data size
Date   Fri, 4 Feb 2005 11:01:12 -0800 (PST)

Joana,

Dan gave excellent advice in response to your initial posting. I note
that none of your messages describe (a) how you tried to convert the
data from SPSS to Stata format, (b) how you tried to open the file in
Stata, and (c) what kind of error message you get from Stata.

Please read the Statalist FAQ (link at bottom of this message), in
particular sections 3 and 4 on how to ask questions that will elicit
a response from other list members.

Friedrich

--- "jmendonca@dem.ist.utl.pt" <jmendonca@dem.ist.utl.pt> wrote:
> Thanks for your answer! Still I didnt manage to work with this
> file. Ive
> tryed to take out some variables from the orginal file and still Im
> not
> able to open it in stata... The stata web site also provided with
> some
> advice that suggests that it is not really possible to do it. is
> there another software package I can turn to? thank you all! Joana 
> 
> Original Message:
> -----------------
> From: Dan Blanchette dan_blanchette@unc.edu
> Date: Thu, 3 Feb 2005 13:54:35 -0500 (EST)
> To: statalist@hsphsun2.harvard.edu
> Subject: Re: st: data size
> 
> 
> Stata offers an online interactive dataset calculator so that you
> can determine how much memory Stata will need to generate that
> dataset:
> 
> http://www.stata.com/support/faqs/data/datacalc.cgi
> 
> So, based on your numbers you seem to have a very large (for a pc)
> dataset,
> about a 10,000 megabyte file (10 gigabytes).
> 
> Your computer may only have 500 megabytes of memory available if
> it's a
> fairly new
> and average pc.
> 
> Since Stata puts the whole dataset into memory, you will need to
> consider
> how many variables and/or observations you really need to use at
> one time.
> 
> These commands will be helpful:
> 
> . describe using "mybighonkingfile.dta"
> 
> . use [a varlist of the vars I need] using "mybighonkingfile.dta"
> 
> . use in 1/10000 "mybighonkingfile.dta"
> 
> . use [a varlist of the vars I need] in 1/10000  using
> "mybighonkingfile.dta"
> 
> . use [a varlist of the vars I need] if [some condition is true] 
> using
> "mybighonkingfile.dta"
> 
> 
> You may be able to reduce the size of your file by converting it
> again from
> SPSS
> to Stata by choosing "compress" (if that's available) in your
> conversion
> software
> package.  This will set your variable lengths to the minimum
> required to
> store
> your data acurately.  If you have categorical data (no decimal
> values),
> this could reduce
> the size of your datafile significantly.
> 
> Hope this helps.
> 
> Dan Blanchette
> 
> Applications Analyst Programmer
> Carolina Population Center UNC-CH
> Dan_Blanchette@unc.edu
> 
> 
> 
> 
> **********************************************
> st: data size
> >From 	  "jmendonc@dem.ist.utl.pt" <jmendonc@dem.ist.utl.pt>
> To 	  statalist@hsphsun2.harvard.edu
> Subject 	  st: data size
> Date 	  Thu, 3 Feb 2005 11:58:19 -0500
> 
> I Have a data base with 1742 variables and 948511 cases built in
> SPSS. Ive
> been trying to transfer it to stata, but I cant open it after. I
> have tryed
> to change the memory and maximum variables allowed, but it doesnt
> seem to
> work... Is it possible to open a dataset this size in Stata or is
> this
> completly unthinkable? Can anyone tell me how I can do it?
> Thank you all!
> Joana Mendonša



		
__________________________________ 
Do you Yahoo!? 
Yahoo! Mail - now with 250MB free storage. Learn more.
http://info.mail.yahoo.com/mail_250
*
*   For searches and help try:
*   http://www.stata.com/support/faqs/res/findit.html
*   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   |   What's new   |   Site index