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 from THRU by at least one blank space.
  • The keywords HIGHEST and LOWEST with THRU indicate the highest and lowest values of a variable. HIGHEST and LOWEST can be abbreviated to HI and LO.
  • Only one THRU specification can be used for each variable or variable list. Each THRU 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.