topic Hash Object in New SAS User

Hash Object

pkp — Wed, 20 Jan 2021 23:27:22 GMT

once I create hash object and depending on hash.find result (if rc=0) How I can create two output table, like if I find the key result goes to one table and if key did not find goes to another table.

Thanks in advance

Re: Hash Object

novinosrin — Wed, 20 Jan 2021 23:45:54 GMT

Hi @pkp Please see if this example helps-



data lookup;
 do key=1 to 3;
  data=rand('uniform')*100;
  output;
 end;
run;

data base;
 do key=1 to 10;
  output;
 end;
run;

data one two;
 if _n_=1 then do;
 if 0 then set lookup;
  dcl hash h(dataset:'lookup');
  h.definekey('key');
  h.definedata('data');
  h.definedone();
 end;
 set base;
 rc=h.find();
 if rc=0 then output one;
 else do;
  call missing(data);
  output two;
 end;
run;

Re: Hash Object

pkp — Fri, 22 Jan 2021 16:20:13 GMT

Thanks a lot