topic Re: Macro with PRXMATCH in SAS Programming

Macro with PRXMATCH

SASdevAnneMarie — Wed, 17 Jun 2026 19:50:50 GMT

Hello Experts,

Today, I'm using the following code to extract rates. I'm wondering if I can create a macro using PRXMATCH to check the values, from 0.50% to 2.70% ?

if (prxmatch("/\b0[,\.]45\s*%/",lb_lg)>0
or prxmatch("/\b0[,\.]45\s*%/",lb_)>0)
or (prxmatch("/\b0[,\.]45\s*%/",lb_lg)>0
or prxmatch("/\b0[,\.]45\s*%/",lb)>0) then
do;
Taux=0.0045;
end;

if (prxmatch("/\b0[,\.]50\s*%/",lb_lg)>0
or prxmatch("/\b0[,\.]50\s*%/",lb)>0)
or (prxmatch("/\b0[,\.]5\s*%/",lb_lg)>0
or prxmatch("/\b0[,\.]5\s*%/",lb)>0) then
do;
Taux=0.005;
end;

if prxmatch("/\b1(\.0\b|\.0\%|\%|\s)/",lb_lg)>0 
or prxmatch("/\b1(\.0\b|\.0\%|\%|\s)/",lb)>0 then
do;
Taux=0.01;
end;

Thank you !

Re: Macro with PRXMATCH

PaigeMiller — Wed, 17 Jun 2026 20:22:00 GMT

I think far easier is to convert the text which you describe as 0.50% to 2.70% to actual numbers and then checking becomes much much much much easier. And then likely no macro is needed.

Re: Macro with PRXMATCH

SASdevAnneMarie — Thu, 18 Jun 2026 15:08:14 GMT

Thank you, Paige Miller, but I didn't fully understand your idea.

Re: Macro with PRXMATCH

Tom — Thu, 18 Jun 2026 15:24:12 GMT

Use the INPUT() function to convert the string into the number it represents and then it will be much easier to compare.

For more help show some examples of the input strings you need to test.

Re: Macro with PRXMATCH

PaigeMiller — Thu, 18 Jun 2026 17:06:11 GMT

@SASdevAnneMarie wrote:

Thank you, Paige Miller, but I didn't fully understand your idea.

The whole idea is that numbers are easier to handle as numbers than if you leave them as text. If there was something I could advise less experienced people to do, it would be to ALWAYS convert text strings which are really numbers to actual numbers.

Re: Macro with PRXMATCH

SASdevAnneMarie — Thu, 18 Jun 2026 19:22:47 GMT

Thank you, Tom.
I'm wondering if I can do this with "prxmatch" :
%macro mymacro(var);
if (prxmatch("/\b0[,\.]&VAR.\s*%/",lb_lg)>0 then ....
%mend;
%mymacro(var=50);

Re: Macro with PRXMATCH

PaigeMiller — Fri, 19 Jun 2026 22:30:36 GMT

@SASdevAnneMarie wrote:
Thank you, Tom.
I'm wondering if I can do this with "prxmatch" :
%macro mymacro(var);
if (prxmatch("/\b0[,\.]&VAR.\s*%/",lb_lg)>0 then ....
%mend;
%mymacro(var=50);

Your are wondering if you can do this with prxmatch. The answer is for you to try it.

it is impossible for me to advise you further since I don't know what you are trying to do. Would you please explain what you are trying to do? Please explain in words without reference to PRXMATCH or any other code.