topic Re: Prxmatch using wildcards within two literals in SAS Programming

Prxmatch using wildcards within two literals

Batman — Fri, 07 Feb 2020 16:58:26 GMT

I want to select five character values within parentheses. The first of 3 characters can be a letter or number and rest should be numbers. This code correctly flags 'ABC(123)' but does not flag 'AZ(J11)' and incorrectly flags 'XYZ123'. What do I need to change?

data a;
input x $10.;
datalines;
ABC(123)
AZ(J11)
ABZ(7)
XYZ123

XYY(1B1)
;
run;

data b;
set a;
flag=0;
if prxmatch('/[0-9]{3}/',x) then flag=1;
run;

Re: Prxmatch using wildcards within two literals

ed_sas_member — Fri, 07 Feb 2020 17:13:08 GMT

Hi @Batman

You can try this:

 if prxmatch('/\([a-z|\d]\d\d\)/i', x) then flag=1;

a parenthesis \(

followed by a letter or a digit [a-z|\d] (nb: case insensitive -> I modifier)

followed by 2 digits d\d

followed by a parenthesis \)

Re: Prxmatch using wildcards within two literals

novinosrin — Fri, 07 Feb 2020 17:18:42 GMT


data a;
input x $10.;
datalines;
ABC(123)
AZ(J11)
ABZ(7)
XYZ123
XYY(1B1)
;
run;

data b;
set a;
Flag= ^^prxmatch('/\([a-z0-9]{1,3}\)/i',x);
run;