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.