I have a list of table containing thousand rows of case IDs. I want to search more than 1 case IDs at one go, say 202001 and 202002, so that the table only display this 2 cases for me to compare the entries.   So far I see there are two ways but they are have limitations:   Method 1: link . Based on this previous thread, one way is to parse the inputs into separate terms. How does one do that? Even so, this method is not scalable; it's hard to say how many search terms the user may entered at any point in time. Method 2: I added a Prompt container at the report section. Added 2 text input boxes in it. However, when I entered 202001 in the first box, and entered 202002 in the second box, the list table did not show the results as expected. Any idea why this did not work? Anyway,this method is also not scalable.   Any ideas for a scalable and "flexible" approach to searching multiple terms in SAS VA? ... View more

I have thousands of rows of subject titles. I only want those contain, say "cat", in the titles. The text input has a search parameter embedded. The list table as the following advanced filter:    ( UpCase('SBJCT_TITLE'n) Contains UpCase(Concatenate( Concatenate(' ', 'Search'p), ' ')) ) OR ( UpCase(Substring( 'SBJCT_TITLE'n, 1, GetLength('Search'p))) = UpCase( 'Search'p) ) OR ( UpCase('SBJCT_TITLE'n) EndsWith UpCase (Concatenate(' ', 'Search'p)) )   The red is for words in the middle, the green for words at the start of the title and the blue for words at the back. However, as you can see in the below picture, it is not what i expected exactly. Titles with "cat" do show up, but words like "catherine" and "catcher" also shows up. Also, the above formula is not perfect as well; what if the title has "cats", instead of "cat"? Any help is appreciated.   ... View more

I have thousand of rows of subject titles. I want to sieve out subject titles based on what I entered in a search parameter. Therefore I have an advanced filter like this in a list table:   Upcase (subject title) contains Upcase (search parameter)   So if I entered "cat" in the text input box (embed with a search parameter), the list table should show all subject titles contain "cat". BUT, here's the problem: I don't want words that contains "cat" in their spelling, like "application" or "allocation", to be part of the results. I only want those that literally have the word "cat" in the subject titles.   Please help. Thank you. ... View more