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;
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!
Still thinking about your presentation idea? The submission deadline has been extended to Friday, Nov. 14, at 11:59 p.m. ET.
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.