Search code examples
macrosspss

How to set missing values for all numeric variables

I have a large dataset with both string and numeric data. The syntax MISSING VALUES ALL (999). did not work because SPSS requires numeric and string variables to be listed separately.
It will be a pain to use MISSING VALUES var1 to varn (999) command because variables are mixed.

Is there a way to define missing values for all numeric variables at once?

Solution

  • This is easily done using spssinc select variables Extension Command. This command puts a list of variables, prepared according to defined contributes, into a macro name. You can then use the macro name in further commands:

    SPSSINC SELECT VARIABLES MACRONAME="!NumVars" /PROPERTIES TYPE=NUMERIC.
MISSING VALUES !NumVars (999).