BookmarkSubscribeRSS Feed
knveraraju91
Barite | Level 11


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

2 REPLIES 2
r_behata
Barite | Level 11
data two;
set one;
pos=find(a,'+');
b=substrn(a,1,pos);
c=substrn(a,pos+1);
drop pos;
run;

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

Register Now

How to Concatenate Values

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 2 replies
  • 823 views
  • 3 likes
  • 3 in conversation