Text input at Page control in SAS VA 8.3.1

[mattneo]

1

[Nigel_Pain · Accepted solution]

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.

[mattneo]

Hi nigel, it works! Thank you very much. I thought the AND operator works
only if warden and EMSC are in the same title, but i want to exclude titles
that contain either or.
Wow seems like rule for inclusion and exclusion interpret the operators
differently. Mind boggling!

[Nigel_Pain]

Glad that's sorted. Please mark it as solved.