how to separate observations from one row

anian — Sun, 28 Oct 2018 19:20:03 GMT

I want to ask how to transform data:

x(num) s(str)

5	aaa
10	aab, aac
7	aad
8	bbb, ccc, ccd
3	xxx

to:

x(num) s(str)

5	aaa
10	aab
10	aac
7	aad
8	bbb
8	ccc
8	ccd
3	xxx

If it helps, my short words have a fixed length (3) [+ possibly comma and blank and next 3].
I will be grateful for help.
A

Re: how to separate observations from one row

novinosrin — Sun, 28 Oct 2018 19:24:07 GMT


data have;
input a s $30.;
cards;
5	aaa
10	aab, aac
7	aad
8	bbb, ccc, ccd
3	xxx
;

data want;
set have;
length new_s $30;
do _n_=1 to countw(s,',');
new_s=strip(scan(s,_n_,','));
output;
end;
run;

topic Re: how to separate observations from one row in New SAS User

how to separate observations from one row

Re: how to separate observations from one row