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
April 27 – 30 | Gaylord Texan | Grapevine, Texas
Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!
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.