Hands-On SAS for Data Analysis

Modifying

There are a couple of key differences between modifying and updating. In modifying, we can only modify the existing table; we cannot create a new output table. For modifying, we do not need the observations to be sorted, whereas it is mandatory for updating.

The following code is used to modify the table:

Data Master;Modify Master A_Alt;By City;Run;

This will result in the following output:

The modification has been requested for the Master dataset. The output dataset is a replica of the A_Alt table. If we use the REPLACE option in the data statement, we get a different answer, as follows:

The REPLACE statement writes the current ...