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;
SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!
Save the date!
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!