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
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.