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
;
Register Today!
Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.