topic Re: PRXCHANGE Simple Pattern Change in SAS Programming

PRXCHANGE Simple Pattern Change

bendsteel6 — Thu, 08 Aug 2019 13:21:26 GMT

Hi,

In the following lines, I simply need to change the '0's in the patterns (08*119*5, 05*119*5, etc.) with a capital "O" (O8*119*5, O5*119*5, etc.) . I've tried with the PRXCHANGE function but I can't seem to get it to work without changing all the other '0's in the datalines.

data test;

input COM_FIELD3 $1000.;

datalines;

CORRECTION:08*119*5 09*119*5 04*119*5 05*119*5 TECHID:1150068 REPAIR DOOR ACCESS PANEL LEFT 1.7 REPAIR DOOR ACCESS PANEL RIGHT 1.7 NON-ADJACENT OVERLAP -0.2

CORRECTION:08*119*5 09*119*5 04*119*5 05*119*5 TECHID:1150042 REPAIR DOOR ACCESS PANEL LEFT 1.7 REPAIR DOOR ACCESS PANEL RIGHT 1.7 NON-ADJACENT OVERLAP -0.2

CORRECTION:08*119*5 09*119*5 04*119*5 05*119*5 TECHID:1150068 REPAIR DOOR ACCESS PANEL LEFT 1.7 REPAIR DOOR ACCESS PANEL RIGHT 1.7 NON-ADJACENT OVERLAP -0.2

;

run;

Any help would be greatly appreciated!

Thanks.

Re: PRXCHANGE Simple Pattern Change

Jagadishkatam — Thu, 08 Aug 2019 14:52:30 GMT

Hope this helps

please try

data test;
input COM_FIELD3& $1000.;
new=prxchange('s/(0)(\d\*)/O$2/',-1,COM_FIELD3);
datalines;
CORRECTION:08*119*5 09*119*5 04*119*5 05*119*5 TECHID:1150068 REPAIR DOOR ACCESS PANEL LEFT 1.7 REPAIR DOOR ACCESS PANEL RIGHT 1.7 NON-ADJACENT OVERLAP -0.2
;
run;

Re: PRXCHANGE Simple Pattern Change

bendsteel6 — Thu, 08 Aug 2019 15:31:18 GMT

Works wonderfully! Thanks!!!

Re: PRXCHANGE Simple Pattern Change

Jagadishkatam — Thu, 08 Aug 2019 15:47:27 GMT

Could you please Mark answers as helpful and correct as appropriate. It helps future users narrow down what responses to look at.

Re: PRXCHANGE Simple Pattern Change

bendsteel6 — Thu, 08 Aug 2019 16:06:33 GMT

I'd love to! How do I do that?

Re: PRXCHANGE Simple Pattern Change

Jagadishkatam — Thu, 08 Aug 2019 16:07:46 GMT

you can see mark as answer and you need to click.

Re: PRXCHANGE Simple Pattern Change

bendsteel6 — Thu, 08 Aug 2019 16:12:23 GMT

Got it, done. Thanks.