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.
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+$/
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.
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.
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+$/
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Select SAS Training centers are offering in-person courses. View upcoming courses for: