Example 4.3 Performing a Table Lookup in a Large, Non-Indexed Lookup Data Set
Efficiently combine two data sets when one is relatively large and not indexed and whose retrieved values remain fairly constant.
|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 ...