Definition of Updating
Updating a SAS data set replaces the values of variables
in one data set (the master data set) with values from another data
set (the transaction data set). If the UPDATEMODE= option in the UPDATE
statement is set to MISSINGCHECK, then missing values in a transaction
data set do not replace existing values in a master data set. If the
UPDATEMODE= option is set to NOMISSINGCHECK, then missing values in
a transaction data set replace existing values in a master data set.
The default setting is MISSINGCHECK.
You update a data set
by using the UPDATE statement along with a BY statement. Both of the
input data sets must be sorted by the variable that you use in the
BY statement.
The following figure shows the results of updating ...
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.
