SAS® Certification Prep Guide: Advanced Programming for SAS®9, Third Edition

Chapter 16Using Lookup Tables to Match Data

Overview

Introduction

Objectives

Using Multidimensional Arrays

Review of the Multidimensional Array Statement

Example

Using Stored Array Values

Overview

Example

Creating an Array

Loading the Array Elements

Reading the Actual Values

Using PROC TRANSPOSE

Overview

Example

Adding Descriptive Variable Names

Merging the Transposed Data Set

Structuring the Data for a Merge

Using a BY Statement with PROC TRANSPOSE

Sorting the Work.Ctarget2 Data Set

Reorganizing the Sasuser.Monthsum Data Set

Sorting the Work.Mnthsum2 Data Set

Completing the Merge

Using Hash Objects as Lookup Tables

Overview

The Structure of a Hash Object

Example

DATA Step Component Objects

Declaring the Hash Object

Instantiating the Hash Object ...