UPDATE Statement

UPDATE (data step statement) UPDATE libref1.master librefn.transact; Must use a BY statement with UPDATE.

Both data sets must be sorted by the BY variables. The master data set must have only one observation for each unique combination of the BY variables. Values are updated for all non-missing values contained in the transaction data set.