Handling Missing Values

By default, if the transaction data set contains missing values for a variable that is common to both the master and the transaction data sets, then the MODIFY statement does not replace values in the master data set with missing values.
If you want to replace values in the master data set with missing values, then you use the UPDATEMODE= option in the MODIFY statement. UPDATEMODE= specifies whether missing values in a transaction data set replace existing values in a master data set.
The syntax for using the UPDATEMODE= option with the MODIFY statement follows:
MODIFY master-SAS-data-set transaction-SAS-data-set <UPDATEMODE=MISSINGCHECK | NOMISSINGCHECK>;
BY by-variable;
MISSINGCHECK prevents missing values in ...

Get Step-by-Step Programming with Base SAS 9.4 now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.