SAS Updating Data Sets

To correct errors in large data sets the update statement can be used:


data new;
update old changes;
by indexvar;
run;


Here changes is a data set containing the corrections to be made to the data set old. Records in old and changes with the same value of the variable indexvar are updated using the information in changes. Missing values in the data set changes do not overwrite data in old.

To concatenate (join) two (or more) data sets together the set statement can be used.