User's dynamic Input at SAS Visual Analytics 7.3

[Rohit_c]

Hi Team,

I have a requirement regarding dynamic Input at SAS Visual Analytics 7.3

User need to select Percentages in Weight Average dropdown for 5 different years (i.e. from 2016 to 2020)

Note: Will be providing  5 individual Weight Average Dropdowns for 5 different years to select different Weight Average for 5 different years. For eg: user might select 20% Weight Average for year 2016, 30% Weight Average for year 2017, 40% Weight Average for year 2018, 60% Weight Average for year 2019 and so on.

I have data from 2016 to 2020 (for the time being ignore 2021 data) which has weight averages from 10% to 100% each for every year.

Refer the attached image:

i.e. If I select 50% from Weight Average drop down, then the below data from all the years from 2016 to 2020 filters for 50% weight and which further displays the data in FTM Actual Column for 50% Weight only.

But I need to showcase data for different Weights to be applied to 5 different years say 20% Weight Average for year 2016, 30% Weight Average for year 2017, 40% Weight Average for year 2018, 60% Weight Average for year 2019 and 30% Weight Average for year 2020 which further I needs to be filter out and show data in FTM Actual Column  for 20% for 2016, 30% for 2017, 40% for 2018, 60% for 2019 and 30% for 2020 wise.

Kindly provide the solution if possible at Visual analytics level (SAS VA 7.3)or provide if there is any other way of doing so using SAS Code.

Note: We are trying using SAS Stored process, would be more happy if you would provide me with stored process solution