BookmarkSubscribeRSS Feed

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

Started ‎07-07-2020 by
Modified ‎07-07-2020 by
Views 2,820

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)

 

Version history
Last update:
‎07-07-2020 04:08 PM
Updated by:
Contributors

sas-innovate-white.png

Missed SAS Innovate in Orlando?

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.

 

Register now

SAS AI and Machine Learning Courses

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.

Get started

Article Tags