topic Re: How to match float values with special charcters like >,<,+,- in SAS Programming

How to match float values with special charcters like >,<,+,-

raja777pharma — Wed, 06 Jul 2022 12:47:20 GMT

Hi,

I am trying to find the float numeric values with prxmatch but I am getting errors as below.

My code is to match the below values is = prxmatch("/^[<>-+]?\d*\.\d+$")

Values to match like = 123 , +23 , 34.56, -234.5, >93, <87, <67.87.

Plase help me to mathc the above values with prxmatch.

Thank you,

Rajasekhar.

PaigeMiller — Wed, 06 Jul 2022 13:01:16 GMT

Please show us the entire log for this DATA step. Copy the log as text, paste it into the window that appears when you click on the </> icon.

raja777pharma — Wed, 06 Jul 2022 13:41:11 GMT

Hi,

Below is log screen shot with proc sql step.

I can't copy the log as the copy is not working from my SAS EG

Thank you,

Rajasekhar.

FreelanceReinh — Wed, 06 Jul 2022 21:14:03 GMT

To prevent ">-+" from being misinterpreted as a range you can escape the minus sign with a backslash:

/^[<>\-+]?\d*\.?\d+$/

Or simply avoid putting it between two characters:

/^[<>+-]?\d*\.?\d+$/