How can I select cases based on missing values?

To select cases based on missing values, use one of the missing value functions:

  • MISSING (variable). Returns true or 1 if the value is system-missing or user-missing.
  • SYSMIS(numeric_variable). Returns true or 1 if the value of a numeric variable is system-missing. (String variables values are never system-missing.)

For example:

SELECT IF MISSING(bdate).

See the topic Missing value functions for more information.