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

Chapter 4. Using Lookup Tables to Match Data

Example 4.1 Performing a Simple Table Lookup 82

Example 4.2 Performing a Table Lookup in a Small Lookup Data Set 85

Example 4.3 Performing a Table Lookup in a Large, Non-Indexed Lookup Data Set 90

Example 4.4 Performing Multiple Lookups for Each Observation in a Data Set 95

Example 4.5 Performing a Table Lookup When the Lookup Data Set Is Indexed 100

Example 4.6 Performing a "Chained" Lookup 103

Table lookup programming involves setting up a table of values that a DATA step or PROC SQL step can reference. Your code then finds a value in the lookup table usually based on information in the observation or row that it is currently processing.

A program that performs table lookup typically puts the table of ...

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