i have created a text input on SAS VA report where user can search last name. i have assigned category last name to the input box so as the user types last name it shows the last name starts with that word.
client don't want this they want to be able to search last name that contains this specific word and filters the results. (like wildcard search)
when searching in “Last_Name” if I search “Hutterian” I only get the records where “hutterian” is the first word in the cell – not records like “Clear Lake Hutterian” or “Three Hills Hutterian”
You can achieve this by:
Thank you so much for your quick response!
I have followed the instructions and created the parameter and assigned it as a role to last name input box. I have also created the filter but its not working for me. Do i also assign the category under roles?
Please see attached file.
Yes, the data item should be in the Category role and its parameter should be in the Parameter role.
I was actually incorrect. The Text Input control should have only the parameter assigned to the Parameter role. Here is an example:
Report has a Text Input control with Origin Parameter assigned to the Parameter role.
List table has these data items: Origin, Make, Invoice. Some valid values for Origin are Asia, Europe, USA.
List table has an Advanced Filter (Filters pane) with this expression:
( UpCase('Origin'n) Contains UpCase('Origin Parameter'p) )
I enter a lowercase letter a in the Text Input control and press ENTER. This is important because the value is not registered until you press ENTER.
The list table is filtered to show USA and Asia.
Thank you once again for your quick response!
I have created the parameter by going into LAST_NAME category and adding a parameter from there.
I have applied the filter on the LAST_NAME T'ext_Input' box not the list table.
Please see the screenshots.
The filter needs to be on the list table.
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.
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.