BookmarkSubscribeRSS Feed
Ujjawal
Quartz | Level 8

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?

4 REPLIES 4
BrunoMueller
SAS Super FREQ

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

Ujjawal
Quartz | Level 8
Thank you so much for your suggestion. I would test it. It seems there is also a restriction on number of rows in a list table. The maximum threshold is 40K. Can we change it?
BrunoMueller
SAS Super FREQ

Hi

 

As far as I know, this is not possible.

 

Bruno

MichelleHomes
Meteorite | Level 14

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.

 

http://support.sas.com/documentation/cdl/en/vaug/68648/HTML/default/viewer.htm#n0r2de9vkep76bn1tjb53...

 

Kind Regards,

Michelle

//Contact me to learn how Metacoda software can help keep your SAS platform secure - https://www.metacoda.com

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

Tips for filtering data sources in SAS Visual Analytics

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.

Discussion stats
  • 4 replies
  • 1273 views
  • 0 likes
  • 3 in conversation