data have;
input id var $20.;
datalines;
1 A,B,C
2 D
3 E,F
;
data want(keep=id newvar);
set have;
do i=1 to countw(var, ',');
newvar=scan(var, i, ',');
output;
end;
run;
data have;
infile cards dlm=' ,' truncover;
input id var : $40. @;
do while(not missing(var));
output;
input var : $40. @;
end;
datalines;
1 A,B,C
2 D
3 E,F
;
2025 SAS Hackathon: There is still time!
Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!