Data Management Solutions Using SAS Hash Table Operations

Chapter 6: Data Tasks Using Hash Table Operations

6.1 Introduction

6.2 Subsetting Data

6.2.1 Two Principal Methods of Subsetting

6.2.2 Simple Data File Subsetting via a Hash Table

6.2.3 Why a Hash Table and Not SQL?

6.2.4 Subsetting with a Twist: Adding a Simple Count

6.3 Combining Data

6.3.1 Left / Right Joins

6.3.2 Merging a Join with an Aggregate

6.3.3 Inner Joins

6.3.4 DO_OVER Versus FIND + FIND_NEXT

6.3.5 Unique-Key Joins

6.4 Splitting Data

6.4.1 Hash Data Split - Sorted Input

6.4.2 Hash Data Split - Unsorted Input

6.5 Ordering and Grouping Data

6.5.1 Reordering Split Outputs

6.5.2 Intrinsic Data Grouping

6.6 Summary

6.1 Introduction

In Chapters 2-4, we have discussed how the hash object tools can be used to perform hash table operations. ...