A Hands-on Introduction to SASĀ® DATA Step Hash Programming Techniques

Kirk Paul Lafler
Software Intelligence Corporation


Abstract

SAS software supports a DATA step programming technique known as hash that enables faster table lookup, search, merge/join, and sort operations. This hands-on workshop reviews match-merge and join techniques, introduces what a hash object is, how hash objects work, and the hash object syntax required to take advantage of the speed that available memory offers. Attendees 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, as well as more complex programming techniques that use a composite key to search for multiple values.