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
THRU
indicates an inclusive list of values. Values must be separated fromTHRU
by at least one blank space. - The keywords
HIGHEST
andLOWEST
withTHRU
indicate the highest and lowest values of a variable.HIGHEST
andLOWEST
can be abbreviated toHI
andLO
. - Only one
THRU
specification can be used for each variable or variable list. EachTHRU
specification 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.