We’re smarter together. Learn from this collection of community knowledge and add your expertise.

Beyond Table Look-up: The Versatile SAS Hash Object

by Regular Contributor on ‎12-22-2017 01:35 PM (2,118 Views)

Authors: Don Henderson ( @DonH ) and Paul Dorfman ( @hashman )

 

This SAS Global Forum presentation highlights additional functionality of the SAS hash object. Soon after the advent of the SAS hash object in Version 9.0, its early adopters realized that its potential functionality is much broader than merely using its fast table look-up capability for file matching. This is because in reality, the hash object is a versatile data storage structure with a roster of standard table operations, such as create, drop, insert, delete, clear, search, retrieve, update, order, and enumerate.

 

hashnutshell.png

 

Since it is memory-resident and its key-access operations execute in O(1) time, it runs them as fast or faster than other canned SAS techniques, with the added bonus of not having to code around their inherent limitations. Another advantage of the hash object, compared to the methods that had existed before its implementation, is its dynamic, run-time nature and the ability to handle I/O all by itself, independently of the intrinsic statements of a DATA step or DS2 program calling its methods.

 

The hash object operations, or their combination thereof, lend themselves to diverse SAS programming functionalities well beyond the original focus on data search and retrieval. In this paper, which may be thought of as a preview of a SAS book being written by the authors, we aim to present this logical connection using the power of example.

 

Online resources

Attachment
Comments
by Frequent Contributor
‎01-03-2018 09:05 AM - edited ‎01-03-2018 10:31 AM

Hi Don,

 

Thanks for sharing. This looks like a must read. Now SAS Communities feels more &more like sascommunity.org with

such great articles. 

I noticed a small issue though,  being unable to display the Slides attached to the post. Maybe my own browser (chromium) is bugging ?

 

Ronan

 

 Edited

by Community Manager
on ‎01-03-2018 09:58 AM

@ronan - try to click the download button to the right of the PDF link.  In some organizations, the file preview window might be blocked by a proxy firewall.  Downloading will get you the full PDF.

by Frequent Contributor
on ‎01-03-2018 10:31 AM

Thanks Chris, this way it works :)

Contributors
Your turn
Sign In!

Want to write an article? Sign in with your profile.


Looking for the Ask the Expert series? Find it in its new home: communities.sas.com/askexpert.