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-2024.png

Available on demand!

Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.

 

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

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