Using a Transaction Data Set

Overview

Sometimes, rather than just combining data from two data sets, you might want to update the data in one data set with data that is stored in another data set. That is, you might want to update a master data set by overwriting certain values with values that are stored in a transaction data set.
For example, suppose the data set Mylib.Empmaster contains data that is outdated. The current data is stored in another data set named Mylib.Empchanges. Mylib.Empmaster contains 148 observations, and Mylib.Empchanges contains six observations. The variable EmpID contains unique values in both data sets.
A partial listing of Mylib.Empmaster and the full listing of Mylib.Empchanges is shown below. Notice that there ...

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.