SAS Tutorial | A Hands On Introduction to SAS DATA Step Hash Programming Techniques

SAS® software supports a DATA step programming technique known as hash that enables faster table lookup, search, merge/join, and sort operations. This SAS tutorial 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. Presenter: Kirk Paul Lafler, Software Intelligence Corporation, SAS Consultant, Application Developer, Programmer, Data Analyst, Educator and Author Session ID: 4415 Topic: Programming Industry: Non-Industry Specific Audience: All Skill Level: All Content outline 00:00 – Welcome 00:42 – Presentation Objectives 01:33 – Tables Used in Examples 02:06 – Understanding Hash Objects 03:49 – Basic Hash Object Syntax 07:02 – Hash Object Examples 07:09 – Exercise #1 – Create a Cars Color Dataset 08:47 – Exercise #2 – PROC PRINT or PROC SQL 10:38 – Exercise #3 – Hash Search / Lookup with Find 13:50 – Exercise #4 – PROC PRINT or PROC SQL 15:37 – Exercise #5 – Find, Has_next and Find_next 18:14 – Exercise #6 – PROC PRINT or PROC SQL 20:10 – Exercise #7 – Hash Match-Merge / Join 23:08 – Exercise #8 – PROC PRINT or PROC SQL 25:10 – Exercise #9 – Ascending Hash Sort 28:20 – Exercise #10 – PROC PRINT or PROC SQL 29:25 – Exercise #11 – Descending Hash Sort 32:41 – Exercise #12 – PROC PRINT or PROC SQL 33:58 - Conclusion Learn more about SAS Software Free SAS Online Training – https://www.sas.com/en_us/training/of... Contact SAS® – https://www.sas.com/en_us/contact.geo... SUBSCRIBE TO THE SAS USERS YOUTUBE CHANNEL #SASUsers #LearnSAS #SASGF https://www.youtube.com/SASUsers?sub_... 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 ►   / sassoftware   Twitter ►   / sassoftware   LinkedIn ►   / sas   Blogs ► https://blogs.sas.com RSS ►https://www.sas.com/rss