1
You need the AND operator rather than OR with NotContains. You want records where the field doesn't contain "warden" AND doesn't contain "EMSC". One of those things where boolean logic doesn't match normal grammatic sense in English.
Incidentally, I notice that in the case of "warden" you are upper-casing the field and then searching for the lower-case text, so that won't exclude any records.
You need the AND operator rather than OR with NotContains. You want records where the field doesn't contain "warden" AND doesn't contain "EMSC". One of those things where boolean logic doesn't match normal grammatic sense in English.
Incidentally, I notice that in the case of "warden" you are upper-casing the field and then searching for the lower-case text, so that won't exclude any records.
Glad that's sorted. Please mark it as solved.
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!See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.
Find more tutorials on the SAS Users YouTube channel.