With SPSS almost all practical data sets are limited
by the amount of available disk space and RAM you have rather than
program limits except some procedures which have specific
variable or case limitations as in the documentation.
After checking your hard disk space, you can simulate a data set for
your computer's practical with something like the syntax below.
You could test your disk storage by doing a save.
You need about 3 or 4 times as much disk space in addition to the
original data.
On my machine with a RAID disk rebuild working at the same time the
print commands produced this for
2,500,000 cases with 1,000 variables
'start generation' 3761530:16:33.480
'start descriptives 1' 3761530:29:41.748
'start descriptives 2' 3761530:30:21.713
13 minutes to simulate the data
40 seconds to do the descriptives
Art Kendall
Social Research Consultants
* cases and items.
new file.
input program.
vector x (1000,f3).
loop id = 1 to 2500000.
loop #p = 1 to 1000.
compute x(#p) = rnd(rv.normal(50,10)).
end loop.
end case.
end loop.
end file.
end input program.
DO IF $CASENUM=1.
PRINT /"'start generation'" $time (time20.3).
END IF.
execute.
DO IF $CASENUM=1.
PRINT /"'start descriptives 1'" $time (time20.3).
END IF.
descriptives variables = x1 to x10 /statistics=all.
DO IF $CASENUM=1.
PRINT /"'start descriptives 2'" $time (time20.3).
END IF.
descriptives variables = x1 to x10 /statistics=all.
On 11/23/2011 6:00 PM, Carlos Renato wrote:
Dear friends
Through the Microsoft Web site got the specifications of Excel. There are
also these information for SPSS somewhere? And for R-Project?
http://office.microsoft.com/en-us/excel-help/excel-specifications-and-limits-HP010073849.aspx
Carlos Renato
Statistician - Brazil
--
View this message in context: http://spssx-discussion.1045642.n5.nabble.com/Limitations-on-the-number-of-cases-and-variables-in-softwares-tp5018600p5018600.html
Sent from the SPSSX Discussion mailing list archive at Nabble.com.
=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD
=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD
Art Kendall
Social Research Consultants
Locked
