Maximum number of cases in an SPSS dataset
Be the first to ask a question
Ask the IBM Support Agent Tool
Technote (troubleshooting)
Problem(Abstract)
What is the maximum number of cases that I can have in an SPSS dataset?
Resolving the problem
SPSS 32 bit can hold up to 2 billion cases in a dataset.
SPSS 64 bit has no real limitation except the specifications of your computer.
The exact number and its calculation is arrived at in the following way.
The file format includes a count of the cases in a 32-bit signed integer. Since one bit is devoted to the sign, the largest number that can be stored there is 2**(31)-1 (2 to the 31st power minus one), or 2,147,493,647.
Remember that the operating system probably keeps the size of each file in bytes in the same kind of integer, so users will likely run into that limit before they hit ours.
Related information
Need more help? Our Statistics forum is Live!
Historical Number
14788
Community questions and discussion
By adding a comment, you accept our Terms of Use. Your comments entered on this IBM Support site do not represent the views or opinions of IBM. IBM, in its sole discretion, reserves the right to remove any comments from this site. IBM is not responsible for, and does not validate or confirm, the correctness or accuracy of any comments you post. IBM does not endorse any of your comments. All IBM comments are provided "AS IS" and are not warranted by IBM in any way.