In SAS VA , i want to have a drop down for Rolling like ' 1 month','3 month'
If 3 month is selected, my NPS data must show a sub total of scores for current month ( which is a parameter in date mmm. format) , current month -1 and current month -2. The result needs to be there in List table.
Input data :-
Month NPS
Jan 10000
Feb 20000
Mar 30000
Here period is in button bar and selection of month is stored in parameter.
rolling input :-
3 months
6 months
If i selected Mar from first source and selected 3 months from rolling source , the output should be as below.
Mar 60000
How to achieve this in SAS VA
Here selection of 3 months is taken from a dummy table. Kindly assist to resolve this.
In SAS VA , i want to have a drop down for Rolling like ' 1 month','3 month'
If 3 month is selected, my NPS data must show a sub total of scores for current month ( which is a parameter in date mmm. format) , current month -1 and current month -2. The result needs to be there in List table.
Input data :-
Month NPS
Jan 10000
Feb 20000
Mar 30000
Here period is in button bar and selection of month is stored in parameter.
rolling input :-
3 months
6 months
If i selected Mar from first source and selected 3 months from rolling source , the output should be as below.
Mar 60000
How to achieve this in SAS VA
Registration is now open for SAS Innovate 2025 , our biggest and most exciting global event of the year! Join us in Orlando, FL, May 6-9.
Sign up by Dec. 31 to get the 2024 rate of just $495.
Register now!
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.