Hash Iterator Objects in SAS: SAS for Beginners (Lesson 33)

By request this is an intro on how you can use keys in SAS to lookup certain values. These objects are very similar to dictionaries in Python or vlookup in SAS and are created within a DATA STEP. You can use this to remove/replace keys, create output datasets, store/retrieve information like in databases and more! Here is the code: data cust; input ID $ State $ Visits; datalines; 2003 NC 4 1239 GA 5 3014 WA 16 7213 WA 2 ; run; declare hiter myiter; myiter = new hiter('h'); if N = 1 then do; length key $5; declare hash myhash(dataset:"work.x"); declare hiter myiter('myhash'); myhash.defineKey('key'); myhash.defineDone(); end; data out; if N = 1 then do; length ID $5; length State $2; length Visits 3; declare hash h(dataset:"work.cust", ordered: 'yes'); declare hiter iter('h'); h.defineKey('ID'); h.defineData('Visits', 'ID'); h.defineDone(); /* Avoid uninitialized variable notes */ call missing(ID, State, Visits); end; rc = iter.first(); do while (rc = 0); if Visits GT 2 then output; rc = iter.next(); end; run; proc print data=work.out; var Visits ID; run; This can be COMPLEX so refer to the documentation here: https://documentation.sas.com/doc/en/... #sasprogramming #sasobjects #sasforbeginners