data one;
input a $10.;
datalines;
aaaa+bbbbb
cccc+ddddd
;
data two;
set one;
b=scan(a,1,'+');
c=scan(a,2,'+');
run;
Dear,
For the above data step, i need to output for b and c vaiables as below. The delimiter should also be included in first word. Please suggest.
b c
aaaa+ bbbbb
cccc+ ddddd
data two;
set one;
pos=find(a,'+');
b=substrn(a,1,pos);
c=substrn(a,pos+1);
drop pos;
run;
SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!
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.