BookmarkSubscribeRSS Feed

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

Started ‎07-07-2020 by
Modified ‎07-07-2020 by
Views 1,945

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 2024

Innovate_SAS_Blue.png

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. 

Register now!

Free course: Data Literacy Essentials

Data Literacy is for all, even absolute beginners. Jump on board with this free e-learning  and boost your career prospects.

Get Started

Article Tags