Use a do until() loop for this:
data have;
input Name :$12. Address &:$24. Account_ID ;
datalines;
Arnold Pitt Street 123
Stallone Pitt Street 123
Willis Pitt Street 123
Smith George Street 123
;
proc sort data=have; by account_id address name; run;
data want;
length allNames $64;
do until(last.address);
set have; by account_id address;
allNames = catx(" and ", allNames, name);
end;
drop name;
rename allNames = name;
run;
proc print data=want noobs; run;
... View more
