SAS software supports a DATA step programming technique known as hash that enables faster table lookup, search, merge/join, and sort operations. In this 28-minute webinar, you'll learn about match-merge and join techniques, hash objects, how hash objects work, and the hash object syntax required to take advantage of the speed that available memory offers. You'll also learn essential hash object programming techniques to define a simple key, sort data, search memory-resident data using a simple key, match-merge (or join) two data sets, handle and resolve collision scenarios where two distinct pieces of data have the same hash value. Finally, you'll be acquainted with more complex programming techniques that use a composite key to search for multiple values.
Video highlights
02:17 - Preview of topics covered in webinar
02:42 - Overview of hash objects
05:01 - Hash object syntax
07:53 - Exercises and examples
10:52 - Hash search or lookup
13:35 - The define key method
16:19 - Hash match-perge or join process
20:01 - An illustration of hash sort using hash objects
Read the Paper
Related resources
GitHub materials
DECLARE Statement: Hash and Hash Iterator Objects (documentation)
