BookmarkSubscribeRSS Feed
Rohit_c
Calcite | Level 5

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:

Forum SS.JPG

 

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

sas-innovate-white.png

Missed SAS Innovate in Orlando?

Catch the best of SAS Innovate 2025 — anytime, anywhere. Stream powerful keynotes, real-world demos, and game-changing insights from the world’s leading data and AI minds.

 

Register now

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 0 replies
  • 617 views
  • 0 likes
  • 1 in conversation