Using the MODIFY Statement

When you submit a DATA step with a MERGE, UPDATE, or SET statement, and if the output data set already exists, SAS creates a second copy of the output data set. Once execution is complete, SAS deletes the original copy of the data set. As a result, the original data set is replaced by the new data set with the same name. The new data set can contain a different set of variables than the original data set. The attributes of the variables in the new data set can be different from those of the original data set.
set statement
In contrast, when you submit a DATA step with a MODIFY statement, the input and output data sets must be ...

Get SAS Certification Prep Guide, 4th Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.