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.
Copyright © 1997 by Jerry Alan Veeh. All rights reserved.