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)
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.
Data Literacy is for all, even absolute beginners. Jump on board with this free e-learning and boost your career prospects.