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
--- "[email protected]" <[email protected]> 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 [email protected]
> Date: Thu, 3 Feb 2005 13:54:35 -0500 (EST)
> To: [email protected]
> 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
> [email protected]
>
>
>
>
> **********************************************
> st: data size
> >From "[email protected]" <[email protected]>
> To [email protected]
> 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/
