Hello,
SAS VIYA : 3.5
SAS Visual Analytics : 8.5
Can anyone advise if is possible to enter multiple values separated by a delimiter (comma, or other) in a text box, to filter a list object?
For example:
The List object has the values: 00000a, 0000ab, 00000c, 00100c, 12345d
I have linked the text object to a parameter and created an advanced filter using "contains" so that if in the text box I enter "0a" the list box will display 0000a and 0000ab.
What I would like to do is to enter:
- "0a","0c" in the text box and the list object to display 00000a, 0000ab, 00000c, 00100c,
or
- "100c", "5d" in the text box and the list object to display 00100c, 12345d
I have tried to allow multiple values in the text parameter so that I can use "in" operator but I couldn't assigned it to the text box parameter role.
Also I'm wondering if we can use wildcards in the text box?
Thank you,
smm662002
it's possible
Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!
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.