Most programmers use the SAS® hash object as a lookup table to help combine two data sets by a common key. This is regrettable because the hash object is a versatile and dynamic data management tool that can be used to do so much more! However, in order to take advantage of its true potential, the understanding of its fundamentals and functionality must be deeper than that sufficient for doing a table lookup using a coding example. This tutorial pursues two goals: Present the fundamentals of the hash object with enough depth to enable a programmer to use it not only to accomplish simple tasks but also use it creatively. Illustrate the functionality of the hash object above and beyond table lookup. After focusing on and based on these underlying works, we will discuss the aspects of the hash object functionality related to concrete data processing tasks, such as: Using the hash object to split, join, unduplicate and aggregate data. Using it to support the creation and updating of a star schema data warehouse. Parameterizing hash table operations to create flexible and scalable programs. Addressing potential issues related to the hash objects memory-resident nature. Session ID: 5306 Presenters: Don Henderson, Henderson Consulting; Paul Dorfman, Dorfman Consulting Topic: Programming Industry: Non-Industry Specific Audience: Programmer Level: intermediate Content Outline 00:00:00 – Introduction 00:07:42 – Part 1 - A Deeper and Wider Look at the Fundamentals 01:06:59 – Overview of Part II – The Hash Object as a BI Tool 01:12 04 – The Sample Data – What it is and How to Download and Create it Locally 01:18:36 – The Hash Object as a Persistent Data Store 01:24:09 – The Hash Object to Perform Simple Data Aggregation 01:35:47 – Adding Meaningful Labels to the Aggregation Results 01:43:18 – Enhancing the Aggregation to Include Multiple (hierarchical) Levels 01:51:27 – The Use of the Hash Object to Calculated Unique Counts 01:58:47 – Multi-Level Aggregation – Hard-Coded 02:10:16 – Multi-Level Aggregation – Data-Driven/Parameterized 02:18:25 – Looping Thru Hash Objects – Introducing Hash of Hashes (HoH) 02:23:46 – Enhancing Parameterized Multi-Level Aggregation Using HoH 02:35:27 – Adding Unique Counts Using HoH 02:41:36 – Summary and How to Contact the Authors Sample Data and Programs If you are interested in creating the data used in Part II of this presentation, please visit Allan Bowe's Bizarro Ball project at https://github.com/allanbowe/BizarroBall/blob/master/README.md You can either download all the programs from our book at https://support.sas.com/downloads/package.htm?pid=2247 Or a zip file which contains just the (slightly modified) programs presented in Part II at https://github.com/sascommunities/sas-global-forum-2020/tree/master/papers/5306-2020-Henderson Learn more about SAS Software Free SAS Online Training – https://www.sas.com/en_us/training/offers/free-training.geo.html?utm_source=youtube.com&utm_medium=referral&utm_campaign=sgf-4406690&utm_content=fAFtKrssHyY Contact SAS® – https://www.sas.com/en_us/contact.geo.html?utm_source=youtube.com&utm_medium=referral&utm_campaign=sgf-4406690&utm_content=fAFtKrssHyY SUBSCRIBE TO THE SAS USERS YOUTUBE CHANNEL #SASUsers #LearnSAS #SASGF https://www.youtube.com/SASUsers?sub_confirmation=1 ABOUT SAS SAS is a trusted analytics powerhouse for organizations seeking immediate value from their data. A deep bench of analytics solutions and broad industry knowledge keep our customers coming back and feeling confident. With SAS®, you can discover insights from your data and make sense of it all. Identify what’s working and fix what isn’t. Make more intelligent decisions. And drive relevant change. CONNECT WITH SAS SAS https://www.sas.com/contact SAS Customer Support https://support.sas.com SAS Communities https://communities.sas.com SAS Analytics Explorers https://explorers.sas.com Facebook https://www.facebook.com/SASsoftware Twitter https://www.twitter.com/SASsoftware LinkedIn https://www.linkedin.com/company/sas Blogs https://blogs.sas.com RSShttps://www.sas.com/rss