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.
Calling all data scientists and open-source enthusiasts! Want to solve real problems that impact your company or the world? Register to hack by August 31st!
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.