remove Delimiter in sas

[sivastat08]

Hi I want after the last Last delimiter text should be extract and replaced _ with Space delimiter in sas 

data ddd;
format Have $50. Want$50.;
Have="\core\event\user_login_failed";
Want=(substr(Have,1,index(Have,"\")+(lengthn("\")-1)));
run;

Have="\core\event\user_login_failed";
Want=user_login_failed

replaced instead of user login failed

Thanks,

Siva

[Tom · Accepted solution]

Hi I want after the last Last delimiter text should be extract and replaced _ with Space delimiter in sas 

Assuming that you mean you want to take the last "word" from a delimited string then use the SCAN() function.

To replace characters use the TRANSLATE() function.

want=translate(scan(have,-1,'\'),' ','_');

[sivastat08]

Thank you very much Tom!