ARCHIVED: In SPSS, how do I drop cases with missing values?
The SELECT
command with the SYSMIS()
function can drop all missing cases from the current SPSS data
set. Consider the following:
SELECT IF NOT (SYSMIS(amount)). SAVE OUTFILE= 'newfile.sav'.
This example drops all cases whose value of the variable amount
is
missing, and then saves this data to an SPSS system file called
newfile.sav
.
If the data set has more than one coding for missing values, as is
often the case for survey data, select all of the different codings
for missing values with the AND
operator:
SELECT IF NOT (SYSMIS(amount1)) AND NOT (SYSMIS(amount2)). SAVE OUTFILE= 'newfile.sav'.
If you have questions about using statistical and mathematical software at Indiana University, contact the UITS Research Applications and Deep Learning team.
This is document afay in the Knowledge Base.
Last modified on 2023-05-09 14:44:14.