topic Re: Prxmatch function in SAS Programming

Prxmatch function

SASdevAnneMarie — Thu, 10 Nov 2022 10:31:02 GMT

Hello Experts,

I would like to hold the code with min value from column a (in my exemple it is T244).

For this, I would like to replace the letter by spaces, and apply the min function.

Do you know please, how to do that with prxmatch function ? Thank you !

data test;
a="T244|T244O|T244S|T339";
/*if prxmatch("m/[A-Z]{1,}/oi",a)> 0 then*/
run;

Re: Prxmatch function

andreas_lds — Thu, 10 Nov 2022 11:50:50 GMT

If you have letters and digits in your data, using compress instead of prxmatch/prxchange is recommended.

data test;
   a="T244|T244O|T244S|T339";
   b = compress(a, '|', 'kd');
run;

Is this the original form of the data or is "a" created to solve the problem?

Re: Prxmatch function

Ksharp — Thu, 10 Nov 2022 12:40:40 GMT

data test;
a="T244|T244O|T244S|T339";

min=9999999;
do i=1 to countw(a,'|');
  temp=scan(a,i,'|');
  value=input(compress(temp ,,'kd'),best32.);
  if value<min then do;want=temp;min=value;end;
end;
drop min i temp value;
run;

Re: Prxmatch function

SASdevAnneMarie — Thu, 10 Nov 2022 15:03:25 GMT

Thank you, Ksharp !