topic Re: How to divide the variable into rows in SAS Programming

How to divide the variable into rows

Ravikumarkummari — Sat, 07 Nov 2015 10:15:39 GMT

Hii all,

i have a data like

Empid	Description
101	A,B,C,D
102	E
103	D,E,F
104	K
105	X,Y,Z

and I want the output like

Empid	Description
101	A
101	B
101	C
101	D
102	E
103	D
103	E
103	F
104	K
105	X
105	Y
105	Z

The description is having any "," then devide that row into multiple(if comma is there between the text).

Any help would be greatly appreciated.

Re: How to divide the variable into rows

FreelanceReinh — Sat, 07 Nov 2015 13:19:04 GMT

Try this:

data want;
set have(rename=(description=d));
length description $1; /* If your real items are not single characters, specify a sufficiently large length! */
do i=1 to countw(d, ',');
  description=scan(d, i, ',');
  output;
end;
drop d i;
run;

Re: How to divide the variable into rows

Ravikumarkummari — Sat, 07 Nov 2015 13:23:48 GMT

Could you suggest me if description column is having special characters then

ex; A,B,C,D

B&C

E,F;C

Re: How to divide the variable into rows

slchen — Sat, 07 Nov 2015 13:39:35 GMT

data have;
x="A,B,C,D";output;
x="B&C"; output;
x="E,F;C";output;
run;

data want;
set have;
do i=1 by 1;
_x=scan(x,i);
if missing(_x) then return;
output;
end;
drop x;
run;