Updating SAS Data Sets

Review of SAS Tools

UPDATE master-SAS-data-set transaction-SAS-data-set; BY identifier-list;: replace the values of variables in one SAS data set with nonmissing values from another SAS data set. Master-SAS-data-set is the SAS data set containing information that you want to update; transaction-SAS-data-set is the SAS data set containing information with which you want to update the master data set; identifier-list is the list of BY variables by which you identify corresponding observations.