Prxmatch function

[SASdevAnneMarie]

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;

[andreas_lds]

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?

[Ksharp · Accepted solution]

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;

[SASdevAnneMarie]

Thank you, Ksharp !