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: Save the Date

 SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!

Save the date!

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
  • 845 views
  • 1 like
  • 3 in conversation