Barite | Level 11

## Prxmatch function

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;
``````

1 ACCEPTED SOLUTION

Accepted Solutions
Super User

## Re: Prxmatch function

``````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;``````
3 REPLIES 3

## Re: Prxmatch function

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?

Super User

## Re: Prxmatch function

``````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;``````
Barite | Level 11

## Re: Prxmatch function

Thank you, Ksharp !
Discussion stats
• 3 replies
• 526 views
• 2 likes
• 3 in conversation