Hi i have a data in this way, now i need to split to Fname,ID,Lname
data name;input name $15.;cards;ravi123kiranvarun74589teja
niranjan965vasanth;run;
Output:
Fname ID Lanme
ravi 123 kiran
varun 74589 teja
niranjan 965 vasanth
Try this
data want; set name; Fname = scan(name, 1, , 'd'); ID = compress(name, , 'kd'); Lanme = scan(name, 2, , 'd'); run;
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
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.
Browse our catalog!