O'Reilly logo

SAS Certification Prep Guide, 4th Edition by SAS Institute

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

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 ...

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