SPSS guide
SPSS “Warnings: There are no valid cases” – how to fix it
Short answer
SPSS shows this warning when every case has been excluded from the analysis. The usual causes are a filter or Split File left on, missing value codes that cover real values, a variable that is completely empty, or group codes in the dialog that don’t match the data.
Check these in order
- Is a filter on? Look for “Filter On” at the bottom of the Data Editor, then use Data › Select Cases › All cases.
- Is Split File on? Use Data › Split File › Analyze all cases.
- Look at the Missing column in Variable View: a range such as 1 through 99 can turn every value into missing.
- Check the variable actually contains numbers: run Frequencies on it.
- In a t-test, check Define Groups uses the codes in your data (for example 1 and 2, not 0 and 1).
Listwise deletion
Many analyses exclude a case if it’s missing any variable in the analysis. If one variable is empty for most people, adding it can wipe out every case. Run Descriptives on each variable to find it, or switch to Exclude cases pairwise where the dialog allows it.
Step-by-step tutorials
Still not sure which test fits?
Answer a few questions and the free tool tells you the test, the SPSS menu path and an APA example.