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
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;
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;
April 27 – 30 | Gaylord Texan | Grapevine, Texas
Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.