topic Re: Prxmatch function for multiple values in SAS Programming

Prxmatch function for multiple values

SASdevAnneMarie — Sat, 08 Mar 2025 17:23:09 GMT

Hello Experts,

To find 1,50% in the data string I apply the function prxmatch("/\b1,50%|\b1.750%/",line)>0.

I get a correct result for 1,50% but when I have 1.50% this function doesn't work (can't find the 1.50%). I don't know if my code is correct.

Thank you for your help.

Re: Prxmatch function for multiple values

Tom — Sat, 08 Mar 2025 19:37:02 GMT

In regular expressions period has special meaning, it will match any single character. If you want to match an actual period you need to code \. in the regular expression.

If you want to match any of a series of characters include them in a set of square brackets.

Example:

data test;
  input string $char40.;
  loc = prxmatch('/\b1[,\.]50%|\b1[,\.]75%/',string);
cards;
1.50%
1,50%
1.75%
1,75%
1.5%
;

Result

Re: Prxmatch function for multiple values

SASdevAnneMarie — Sat, 08 Mar 2025 23:26:32 GMT

Thank you, Tom!
As I understand, if I write prxmatch("/\b1.50%/",line)>0 the function is looking for 1 or 50?

Re: Prxmatch function for multiple values

Tom — Sun, 09 Mar 2025 03:20:11 GMT

@SASdevAnneMarie wrote:
Thank you, Tom!
As I understand, if I write prxmatch("/\b1.50%/",line)>0 the function is looking for 1 or 50?

No. It will be look for things like:

1.50%
1,50%
1A50%
1x50%

If you want to look for 1 or 50 you would use | just like your original post used | so it could search for 1,50% or 1.750%

Here is code that would make words that consist of only 1 or 50.

 prxmatch('/\b(1|50)\b/',line)

Re: Prxmatch function for multiple values

SASdevAnneMarie — Sun, 09 Mar 2025 09:39:07 GMT

Thank you, Tom.
I not understand the first explication "In regular expressions period has special meaning, it will match any single character. "

Re: Prxmatch function for multiple values

SASdevAnneMarie — Sun, 09 Mar 2025 11:26:53 GMT

Thank you ! If I need to get 1.50 or 1.50 % or 1.50% can I write prxmatch("/\b1[,\.]50\s*%/",line)>0 ?
s*% is right ?

Re: Prxmatch function for multiple values

Tom — Sun, 09 Mar 2025 18:16:57 GMT

@SASdevAnneMarie wrote:
Thank you ! If I need to get 1.50 or 1.50 % or 1.50% can I write prxmatch("/\b1[,\.]50\s*%/",line)>0 ?
s*% is right ?

Looks reasonable. Try it out. I posted a simple example data step before. So use something like that to quickly test it on a lot of different strings.