Example 4.3 Performing a Table Lookup in a Large, Non-Indexed Lookup Data Set
Goal
Efficiently combine two data sets when one is relatively large and not indexed and whose retrieved values remain fairly constant.
Example Features
| Featured Step | PROC FORMAT and DATA step |
| Featured Step Options and Statements | PROC FORMAT CNTLIN= option DATA step: PUT function, END= data set option |
| Related Technique | Hash object in the DATA step |
| A Closer Look | Using Formats to Perform a Table Lookup Building a Format Dynamically with CNTLIN= |
Input Data Sets
PROVIDERS contains information about providers in a healthcare system. The first 12 of 279 observations are presented.
PROVIDERS
provider_ provider_ provider_
Obs id name specialty type 1 0025 Davis, WU Family Medicine ...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.
