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”)
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?
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
SAS INNOVATE 2024
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.