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 ...
Get Step-by-Step Programming with Base SAS 9.4 now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
