topic Hash table and find values from other table in SAS Programming

Hash table and find values from other table

GN0001 — Wed, 11 May 2022 19:06:08 GMT

Hello team,
I have a hash table created:
Data product. Result(drop =IDkey);
If _N_ = 0 then set thisdata;
Declare hash h(dataset: ‘thisdata’);
h.define key =(‘IDkey’);
h.definedata( ‘thisfield’ ‘that field’)
h.defineDone();
Do until (done)
Set sometable end=done;
rc=h.find(key:IDkey);
If rc ne 0 then then do
Thisfield= “ “;
That field=“ “;
End;
Output;
End;
Stop;
Run;

I understood by end of h.define(done), I can’t understand lines afterwards. Any help os greatly appreciated. 🙏🙏🙏🙏blue & blue

Re: Hash table and find values from other table

Astounding — Wed, 11 May 2022 20:43:09 GMT

rc=

Based on the observation from SOMETABLE, look in the hash table for matching value for IDKey. Retrieve the values for 'Thisfield' and 'Thatfield' from the hash table, based on a match for IDKey.

if rc ne 0

If the search through the hash table does not find a matching value for IDKey, assign missing values to 'Thisfield' and 'Thatfield'