topic Re: remove Delimiter in sas in New SAS User

remove Delimiter in sas

sivastat08 — Tue, 16 Jul 2019 17:20:58 GMT

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 — Tue, 16 Jul 2019 17:27:13 GMT

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 — Wed, 17 Jul 2019 08:49:11 GMT

Thank you very much Tom!