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.
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
DECLARE Statement: Hash and Hash Iterator Objects (documentation)
Catch the best of SAS Innovate 2025 — anytime, anywhere. Stream powerful keynotes, real-world demos, and game-changing insights from the world’s leading data and AI minds.
The rapid growth of AI technologies is driving an AI skills gap and demand for AI talent. Ready to grow your AI literacy? SAS offers free ways to get started for beginners, business leaders, and analytics professionals of all skill levels. Your future self will thank you.