topic Filter Cases by Case title using multiple keywords in SAS Visual Analytics

Filter Cases by Case title using multiple keywords

mattneo — Mon, 08 Apr 2019 14:12:11 GMT

Hi. I have a database connected to SAS VA. This database contains all customer correspondence, and one of the data item is “Case title”, which is the subject title for a case. Out of the hundreds and thousands of cases in the database, I want to retrieve cases that have specified keywords (eg. “poor service”, “bad attitude”) in the title.

I went to advanced filter and use the following expression:

UPCASE( Case title) contains UPCASE(“poor service”)

Sure enough, the list table shows only cases with “poor service” in the titles. However I also need cases with “bad attitude” in the same list table. I tried the following with the OR operator:

UPCASE( Case title) contains OR( UPCASE(“poor service”)

UPCASE(“bad attitude”)

It doesn’t work. Threw up an error saying Boolean used but expecting Character or something. Please help. How can I retrieve cases based on a set of keywords?

Re: Filter Cases by Case title using multiple keywords

Sam_SAS — Mon, 08 Apr 2019 15:36:26 GMT

It is inelegant, but you should be able to use:

OR (UPCASE(Case title) contains UPCASE("poor service")
UPCASE(Case title) contains UPCASE("bad attitude")))

That is, repeat the entire condition for each OR case.

There may also be a much better solution someone else could offer 🙂

Re: Filter Cases by Case title using multiple keywords

mattneo — Tue, 09 Apr 2019 02:59:10 GMT

Thanks sam. It works! I actually have more keywords so i guess i have to keep adding OR operators. If theres a more efficient way, like to reference a list of words the user enters, will love to hear it.... But this will do for now. Thks again