topic Re: How to replace date within a string in SAS Procedures

How to replace date within a string

sachink — Wed, 01 Apr 2015 01:34:36 GMT

I need to replace value in a string - "the enddate of employee1 is 15/10/2012" to "the enddate of employee1 is". I am using tranwrd function as x1 = (x,"15/10/2012"," ");

This doesn't seem to be working. Any advise?

Re: How to replace date within a string

Ksharp — Wed, 01 Apr 2015 13:50:04 GMT

data _null_;

a="the enddate of employee1 is 15/10/2012";

b=prxchange('s/\d+\/\d+\/\d+//',-1,a);

put a= b=;

run;

Re: How to replace date within a string

Jagadishkatam — Wed, 01 Apr 2015 14:50:41 GMT

I am not sure if you have actually tried the below code with tranwrd function. This is working, please check

data have;

length x $200.;

x="the enddate of employee1 is 15/10/2012";

x1 = tranwrd(x,"15/10/2012"," ");

run;

Thanks,

Jag