Example 7.3 Modifying an Indexed Master Data Set in Place
Goal
Modify a master data set in place based on information supplied by a transaction data set. Observations can be added to, modified in, or deleted from the master data set. The master data set and transaction data set do not contain any multiple occurrences of the key variables.
Example Features
| Featured Step | DATA step |
| Featured Step Options and Statements | MODIFY statement in conjunction with the OUTPUT, REPLACE, and REMOVE statements
KEY= option in the MODIFY statement _IORC_ automatic variable Macro function %SYSRC |
Input Data Sets
Data set POLICIES contains data for 12 policy holders. Assume it has a simple index on variable ID. The POLICIES data set is also used in Example 4.5.
Get Combining and Modifying SAS® Data Sets: Examples Second 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.
