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

[raja777pharma]

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]

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]

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 · Accepted solution]

Hi @raja777pharma,

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+$/