BookmarkSubscribeRSS Feed
amol2939
Calcite | Level 5
I have a lab result and want to filter only character result value
Eg: O Positive
Pale yellow
Any idea how to filter
7 REPLIES 7
ChrisNZ
Tourmaline | Level 20

What's the criterion? 

No digits allowed? Only letters allowed? Punctuation allowed? Spaces allowed?

amol2939
Calcite | Level 5
Only letters allowed
ChrisNZ
Tourmaline | Level 20
amol2939
Calcite | Level 5
Space allowed
But no numeric value must be there
ChrisNZ
Tourmaline | Level 20

To test for numerics:

  where ^anydigit(VAR) ;

To test for non- letters and spaces:

  where ^prxmatch('/[^ a-zA-Z]/');

 

amol2939
Calcite | Level 5
Spaces allowed
andreas_lds
Jade | Level 19

To stop guessing what you really need, please post data you have in usable form and the expected result.

SAS Innovate 2025: Register Now

Registration is now open for SAS Innovate 2025 , our biggest and most exciting global event of the year! Join us in Orlando, FL, May 6-9.
Sign up by Dec. 31 to get the 2024 rate of just $495.
Register now!

How to Concatenate Values

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 7 replies
  • 879 views
  • 1 like
  • 3 in conversation