topic Re: I have a alphanumric string now i want to split it into 3, Fname, ID & LName in SAS Programming

I have a alphanumric string now i want to split it into 3, Fname, ID & LName

ravikiran2627 — Sun, 27 Mar 2022 18:40:17 GMT

Hi i have a data in this way, now i need to split to Fname,ID,Lname

data name;
input name $15.;
cards;
ravi123kiran
varun74589teja

niranjan965vasanth
;
run;

Output:

Fname ID Lanme

ravi 123 kiran

varun 74589 teja

niranjan 965 vasanth

PeterClemmensen — Sun, 27 Mar 2022 18:47:36 GMT

Try this

data want;
   set name;
   Fname = scan(name, 1, , 'd');
   ID = compress(name, , 'kd');
   Lanme = scan(name, 2, , 'd');
run;