Chapter 6: Hash Programming as an Alternative to SQL
Hash programming is any programming using hash objects. The hash object and hash iterator enable you to store, search, and query data from lookup tables. Hash objects are nothing new in SAS; they have been around for some time in arrays, SQL (including the Internal Optimizer), and indexes. PROC SQL uses hashing for some joins. However, it does not use the Hash Object facility that is described in this chapter. Instead, PROC SQL provides its own hashing capabilities. Since SAS 9.1, it is possible to program hash objects specifically. You can currently execute hash programming in the DATA step or in the DS2 programming language (PROC DS2 and PROC HPDS2). DS2 is included with Base SAS; its syntax ...
Get Advanced SQL with SAS now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
