SPSSX Discussion

Number of cases in a sav file

Classic

List

Threaded

5 messages Options

Anthony Bressy

Number of cases in a sav file

Hi,

I would like to work on a very large database with SPSS V20.

My questions are :

- What is the maximum number of cases in a sav file ?

- Can I make statistics on several data files (total of the files) ?

Thanks in advance.

Anthony Bressy

eliana242

Re: Number of cases in a sav file

Hi,
I worked with a file of nearly 10,000 cases but in SPSS V15. And to make SPSS statistical calculations only takes 500 variables

Dean Howlin

Automatic reply: Number of cases in a sav file

I am out of the office today. Please contact my colleagues Niall or Stephen if you need assistance.

[hidden email];[hidden email]

David Marso

Re: Number of cases in a sav file

Administrator

In reply to this post by Anthony Bressy

"I would like to work on a very large database with SPSS V20."
Define very large! Some people think 10,000 is very large while others think of 10,000,000 as downright trivial.

"What is the maximum number of cases in a sav file ?"
HUGE! in excess of 2 Billion! Likely more with 64 bit SPSS and OS.

- Can I make statistics on several data files (total of the files) ?
See ADD FILES command or look deeper into SQL queries.

-

Anthony Bressy wrote

Hi,

I would like to work on a very large database with SPSS V20.

My questions are :

- What is the maximum number of cases in a sav file ?

- Can I make statistics on several data files (total of the files) ?

Thanks in advance.

Anthony Bressy

Please reply to the list and not to my personal email.
Those desiring my consulting or training services please feel free to email me.
---
"Nolite dare sanctum canibus neque mittatis margaritas vestras ante porcos ne forte conculcent eas pedibus suis."
Cum es damnatorum possederunt porcos iens ut salire off sanguinum cliff in abyssum?"

Albert-Jan Roskam

Re: Number of cases in a sav file

----- Original Message -----

> From: David Marso <[hidden email]>
> To: [hidden email]
> Cc:
> Sent: Thursday, September 6, 2012 10:05 PM
> Subject: Re: [SPSSX-L] Number of cases in a sav file
>
>& quot;I would like to work on a very large database with SPSS V20."
> Define very large! Some people think 10,000 is very large while others
> think of 10,000,000 as downright trivial.
>
>
> "What is the maximum number of cases in a sav file ?"
> *HUGE!* in excess of 2 Billion! Likely more with 64 bit SPSS and OS.
>
> - Can I make statistics on several data files (total of the files) ?
> See ADD FILES command or look deeper into SQL queries.
>

You should try to do as much as possible on the database. So rather a UNION ALL than an ADD FILES,
rather JOIN than a MATCH FILES. And do not use SELECT * but specify only the vars you need. It's probably
also a good idea to do the sorting on the database (so ORDER BY, not SORT CASES).
Also, be sure to let your GET DATA be followed by a call to CACHE, or else your sql query will be executed many times.

=====================
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