topic Help with replace text in SAS Programming

Help with replace text

hhchenfx — Sun, 02 Mar 2014 03:00:21 GMT

Hello Everyone,

I am using prxchange to replace text. I can replace the string '&& &&' but can not do with '&& )'.

Can you show me how to fix it?

Many thank and have a nice weekend.

HHC

data have;

input old $20. ;

datalines;

change1 && && face

change2 && && askljklj

change3 dfa

xlx && )

nochange && )

;

run;

data want;

set have;

new = prxchange('s/&& &&/&&/', 1, old);

new2 = prxchange('s/& )/)/', 1, old);

run;

Re: Help with replace text

hhchenfx — Sun, 02 Mar 2014 03:08:19 GMT

oh I got it.

data one;

input old $20. ;

datalines;

change1 && && face

change2 && && askljklj

change3 dfa

xlx & )

run;

data two;

set one;

new = prxchange('s/&& &&/&&/', 1, old);

new2 = prxchange('s/& \)/kkk/', 1, old);

run;