Hello guys,
I would like to apply a search on a drop-down control. Do you know if it's possible or the best workaround for this functionality?
The data on the Drop-down has too many elements and the user would like to do a search to find a specific element.
Thank you in advance.
Cheers,
Rorigo
Hello Teja,
thank you for your answer. I've already tried that before without success.
How can I search for a specific element in a List Control?
Regards,
Rodrigo
Work around:
Add a Text Input-control to your report. Create a parameter on this Text input (say Parameter1).
Add a filter to your Dropdown-object like this:
( LowerCase('ElementName'n) Contains LowerCase('Parameter1'p) )
As the user inputs text in the Text Input-control, the possible choises in the DropDown is limited to those elements that contains the inputted text. The full list of elements is showed in the Drop Down when the TextInput is empty.
Save $250 on SAS Innovate and get a free advance copy of the new SAS For Dummies book! Use the code "SASforDummies" to register. Don't miss out, May 6-9, in Orlando, Florida.
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.