https://communities.sas.com/t5/SAS-Tips-from-the-Community/SAS-Tip-Table-lookup-operations-are-fast-with-the-Hash-object/m-p/436351#M41 <P>A hash object permits table lookup operations to be performed considerably faster than other available methods found in the SAS system. Unlike a DATA step merge or PROC SQL join where the SAS system repeatedly accesses the contents of a table stored on disk to perform table lookup operations, a hash object reads the contents of a data set into memory once allowing the SAS system to repeatedly access it, as necessary.</P> <HR /> <P>Thanks to Kirk Paul Lafler&nbsp;for this tip. Read more details in this paper from WUSS 2017:&nbsp;<A href="https://www.lexjansen.com/wuss/2017/19_Final_Paper_PDF.pdf" target="_blank" rel="noopener">A Hands-on Introduction to SAS DATA Step Hash Programming Techniques</A>.</P> Mon, 28 Jan 2019 18:15:18 GMT SAS_Tipster 2019-01-28T18:15:18Z https://communities.sas.com/t5/SAS-Tips-from-the-Community/SAS-Tip-Table-lookup-operations-are-fast-with-the-Hash-object/m-p/436351#M41 <P>A hash object permits table lookup operations to be performed considerably faster than other available methods found in the SAS system. Unlike a DATA step merge or PROC SQL join where the SAS system repeatedly accesses the contents of a table stored on disk to perform table lookup operations, a hash object reads the contents of a data set into memory once allowing the SAS system to repeatedly access it, as necessary.</P> <HR /> <P>Thanks to Kirk Paul Lafler&nbsp;for this tip. Read more details in this paper from WUSS 2017:&nbsp;<A href="https://www.lexjansen.com/wuss/2017/19_Final_Paper_PDF.pdf" target="_blank" rel="noopener">A Hands-on Introduction to SAS DATA Step Hash Programming Techniques</A>.</P> Mon, 28 Jan 2019 18:15:18 GMT https://communities.sas.com/t5/SAS-Tips-from-the-Community/SAS-Tip-Table-lookup-operations-are-fast-with-the-Hash-object/m-p/436351#M41 SAS_Tipster 2019-01-28T18:15:18Z