I have a report with customer ID, customer Name, and account count field.. i have inserted a cross tab to display customer Name wise account count. It has more than 1000 records (rows). Now i wast to insert a input field, where user can type/paste a set of names (e.g. Alfed,Carol, Henry) and the corresponding value should appear there in cross tab or graph.
I have already tried 'Text-input' option but it could take only one value to filter, not taking multiple.
We would like to paste set of customer name or upload a excel/csv file to filter out the report in the view. User can accordingly view interested record and download if needed.
you may consider below data for example... and need a filter button on dashboard of SAS VA to filter data by names.
data WORK.CLASS(label='Student Data'); infile datalines dsd truncover; input Name:$8. Sex:$1. Age:32. Height:32. Weight:32.; datalines; Alfred M 14 69 112.5 Alice F 13 56.5 84 Barbara F 13 65.3 98 Carol F 14 62.8 102.5 Henry M 14 63.5 102.5 ;;;;
I believe the answer in this thread:
might help you. I am not sure about pasting in a large number of names, but it should work for reasonably small numbers of input values.
Let us know.
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.