data a;
input (RecordNo ID1 ID2 ID3) ($);
cards;
001 A001 A112 A511
002 A005 A234 A345
003 A002 A123 A112
004 A003 A004 A234
;
run;
data b;
input (Id Name) ($);
cards;
A001 Rick
A002 David
A003 Ron
A004 Pat
A005 Tom
;
run;
data want;
if _n_=1 then do;
if 0 then set b;
declare hash h(dataset:'b');
h.definekey('id');
h.definedata('name');
h.definedone();
end;
set a;
array x{*} $ 32 name1-name3;
array y{*} $ 32 id1-id3;
do i=1 to dim(x);
call missing(name);
id=y{i};
rc=h.find();
x{i}=name;
end;
drop i id name rc;
run;
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.