Data in single row, need in multiple rows

[shikhar6339]

Data I have:

1 A,B,C

2 D

3 E,F

Data I want:

1 A

1 B

1 C

2 D

3 E

3 F

[Kurt_Bremser]

data want;
set have;
do i = i to countw(string,',');
  newstring = scan(string,i,',');
  output;
end;
drop i string;
run;

Set proper length for newstring as needed.

[PeterClemmensen]

Welcome to the SAS Community 🙂

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;

Result:

id  newvar
1   A
1   B
1   C
2   D
3   E
3   F

[Ksharp]

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
;