BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
GPatel
Pyrite | Level 9
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;
1 ACCEPTED SOLUTION

Accepted Solutions
ChrisNZ
Tourmaline | Level 20

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() ?

 

View solution in original post

1 REPLY 1
ChrisNZ
Tourmaline | Level 20

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() ?

 

SAS Innovate 2025: Register Now

Registration is now open for SAS Innovate 2025 , our biggest and most exciting global event of the year! Join us in Orlando, FL, May 6-9.
Sign up by Dec. 31 to get the 2024 rate of just $495.
Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 1 reply
  • 1099 views
  • 1 like
  • 2 in conversation