Step-by-Step Programming with Base SAS 9.4

Handling Missing Values

If you update a master data set with a transaction data set, and the transaction data set contains missing values, then you can use the UPDATEMODE= option in the UPDATE statement to tell SAS how you want to handle the missing values. The UPDATEMODE= option 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 UPDATE statement follows:

UPDATE master-SAS-data-set transaction-SAS-data-set <UPDATEMODE=MISSINGCHECK | NOMISSINGCHECK>;

BY by-variable;

The MISSINGCHECK value in the UPDATEMODE= option prevents missing values in a transaction data set from replacing values in a master data set. This is the default. The ...