Hash Object

[pkp]

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

[novinosrin · Accepted solution]

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;

[pkp]

Thanks a lot