topic Re: HASH Output in SAS Programming

HASH Output

GPatel — Thu, 01 Jun 2017 21:12:02 GMT

Here is my sample template. How can I output Matched and Unattached records by a key variable to a work.match and work.unmatch dataset ?

DATA NAME;
IF 0 THEN SET SMALL_DATA_SET;
if _N_ = 1 then do;
declare hash HASH_NAME(dataset: "SMALL_DATA_SET", multidata: 'y');
HASH_NAME.defineKEY("YOUR_KEY_VARIABLE");
HASH_NAME.defineData (ALL:'YES');
HASH_NAME.defineDone();
END;
set BIG_DATA_SET;
IF HASH_NAME.FIND(KEY:YOUR_KEY_VARIABLE) = 0 THEN OUTPUT;
RUN;

Re: HASH Output

ChrisNZ — Fri, 02 Jun 2017 03:02:11 GMT

Like this?


data MATCHED UNMATCHED; 
  if 0 then set SMALL_DATA_SET; 
  if _N_ = 1 then do;  
    declare hash HASH_NAME(dataset: "SMALL_DATA_SET", multidata: 'y'); 
    HASH_NAME.defineKey("YOUR_KEY_VARIABLE"); 
    HASH_NAME.defineData (ALL:'YES'); 
    HASH_NAME.defineDone();
  end; 
  set BIG_DATA_SET; 
  if HASH_NAME.find()=0 then output MATCHED; 
  else output UNMATCHED; 
run;

Do you really need definedata() ?