Carpenter's Guide to Innovative SAS Techniques

Chapter 6 Table Lookup Techniques

6.1 A Series of IF Statements—The Logical Lookup

6.2 IF -THEN/ELSE Lookup Statements

6.3 DATA Step Merges and SQL Joins

6.4 Merge Using Double SET Statements

6.5 Using Formats

6.6 Using Indexes

6.6.1 Using the BY Statement

6.6.2 Using the KEY= Option

6.7 Key Indexing (Direct Addressing)—Using Arrays to Form a Simple Hash

6.7.1 Building a List of Unique Values

6.7.2 Performing a Key Index Lookup

6.7.3 Using a Non-Numeric Index

6.8 Using the HASH Object

A table lookup is performed when you use the value of a variable (e.g., a clinic number) to determine the value of another variable (e.g., clinic name). Often this ...