topic Re: how to splite the words before cama after cama in SAS Programming

how to splite the words before cama after cama

teja5959 — Tue, 05 Feb 2019 08:48:32 GMT

having data

a b

1148 arm

1149 leg

1150 arm;leg;trunk

1151 arm; leg

i want data

a b c

1148 arm arm

1149 leg leg

1150 arm;leg;trunk arm

1150 arm;leg;trunk leg

1150 arm;leg;trunk trunk

1151 arm;leg arm

1151 arm;leg leg

Re: how to splite the words before cama after cama

PeterClemmensen — Tue, 05 Feb 2019 09:21:58 GMT

Do like this

data have;
input a $ b:$20.;
datalines4;
1148 arm
1149 leg
1150 arm;leg;trunk
1151 arm;leg
;;;;

data want(drop=i);
   set have;
   do i = 1 to countw(b, ';');
      c = scan(b, i, ';');
      output;
   end;
run;