I need to report information at customer level. I have around 60K customers. The data is shown below for 1 customer. The same kind of information would be for other 60k customers. There are 7 metrics against each customer so there would be (60K * 7 =420,000 rows in the data).
Customer | Metrics | Scores |
ABC | Balance | 100005 |
ABC | Income | 25000 |
ABC | Tenure | 20 |
ABC | Products | A |
ABC | Category | AA |
ABC | Risk | A+ |
ABC | Value | B |
My requirement is to have a drop down to select a customer and the respective metrics scores would be displayed in a list table. The problem i am facing here is SAS VA is unable to take 60K unique customers' name in a drop down. The data do not get loaded in the drop down. Is there a way to do it? Any option other than drop down?
Hi
How about using a different approach, enter parts of a customer name and filter the list table based on the entered text. See this video https://www.youtube.com/watch?v=g-ZWxX4jxRU by @TeriPatsilaras
Have not tested it, but using a Text Input Control where you assign your category, allows you to start typing the first letters of the customer name
Bruno
Hi
As far as I know, this is not possible.
Bruno
Hi,
It might be possible to change the default cardinal it's setting of 40,000 as outlined in the documentation, however I'd question whether the increase client resource consumption is wise and perhaps a better approach to address your requirement with filtering the data first is best.
Kind Regards,
Michelle
Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.
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.