topic Re: Where clause in SAS Programming

Where clause

amol2939 — Thu, 19 Mar 2020 02:57:44 GMT

I have a lab result and want to filter only character result value
Eg: O Positive
Pale yellow
Any idea how to filter

ChrisNZ — Thu, 19 Mar 2020 03:06:38 GMT

What's the criterion?

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

amol2939 — Thu, 19 Mar 2020 03:26:05 GMT

Only letters allowed

ChrisNZ — Thu, 19 Mar 2020 03:34:57 GMT

O positive contains a space

amol2939 — Thu, 19 Mar 2020 03:43:00 GMT

Space allowed
But no numeric value must be there

amol2939 — Thu, 19 Mar 2020 03:45:39 GMT

Spaces allowed

ChrisNZ — Thu, 19 Mar 2020 20:31:44 GMT

To test for numerics:

where ^anydigit(VAR) ;

To test for non- letters and spaces:

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

andreas_lds — Thu, 19 Mar 2020 06:15:03 GMT

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