topic Re: Perl expression in SAS Programming

Perl expression

RajasekharReddy — Thu, 24 May 2018 14:08:37 GMT

Hello ,

Please help to change "MCLAUREN" value as "McLAUREN" by using Perl Expression (PRXCHANGE)

I tried below code but didn't work for me

data _null_;
   x = 'MCLAUREN';
   y = prxchange("s/ (MC) /\u\L$1/i", -1, x);
   put y=;
run;

Thanks in Advance

HB — Thu, 24 May 2018 15:05:10 GMT

Look at the example on Page 9 of this:

I think you want to set your regular expression first like

re = prxparse('s/ (MC) /\u\L$1/i');

and then call it like they do

cleanname= prxchange( re, 1, oldname);

kiranv_ — Thu, 24 May 2018 23:17:44 GMT

something like this

data _null_;
   x = 'MCLAUREN';
   y = prxchange("s/^(MC)(.+)/Mc$2/i", -1, x);
   put y=;
run;

jim_cai — Fri, 25 May 2018 01:13:58 GMT

or something like prxchange("s/^MC(.+)/Mc$1/", -1, x), since "Mc" is typed in manually so it is unnecessary to catch "MC".

Patrick — Fri, 25 May 2018 01:44:56 GMT

Or like this:

data _null_;
   x = 'pEter MClAUREN & ian macIllIoMChadha';
   y = prxchange("s/\b(MC|MAC)(\w)/\1\u\2/i", -1, propcase(x));
   put y=;
run;

Result:

y=Peter McLauren & Ian MacIlliomchadha

Ksharp — Fri, 25 May 2018 14:01:03 GMT

data _null_;
   x = 'MCLAUREN';
   y = prxchange("s/^(MC)/\u\L$1/i", 1, x);
   put y=;
run;