Specifying Ranges of Missing Values (MISSING VALUES command)
A range of values can be specified as missing for numeric variables but not for string variables.
- The keyword
THRUindicates an inclusive list of values. Values must be separated fromTHRUby at least one blank space. - The keywords
HIGHESTandLOWESTwithTHRUindicate the highest and lowest values of a variable.HIGHESTandLOWESTcan be abbreviated toHIandLO. - Only one
THRUspecification can be used for each variable or variable list. EachTHRUspecification can be combined with one additional missing value.
Example
MISSING VALUES V1 (LOWEST THRU 0).
- All negative values and 0 are declared missing for the variable V1.
Example
MISSING VALUES V1 (0 THRU 1.5).
- Values from 0 through and including 1.5 are declared missing.
Example
MISSING VALUES V1 (LO THRU 0, 999).
- All negative values, 0, and 999 are declared missing for the variable V1.