O'Reilly logo

Combining and Modifying SAS® Data Sets: Examples Second Edition by Michele M. Burlew

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 StepDATA step
Featured Step Options and StatementsMODIFY 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.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required