Is it possible to create lag or lead values from an aggregate field.
I am aware it can be created by using simple metric using periodic option but I have to use aggregate field to create lag, lead and avg 3 month values.
Service_Time Sales1 Lag Lead Rolling_3_Months_Avg
Jan2019 10 - 20 -
Feb2019 20 10 30 -
Mar2019 30 20 40 20
Apr2019 40 30 50 30
May2019 50 40 - 40
I guess it will help you in understanding my requirement.
I know it is pretty easy to create through sas coding but here we don't have any control on data side.
This has to be created at SAS VA and base field is an aggregate measure which we are creating at SAS VA level.
And limitation is SAS VA doesn't allow to use aggregate measure to create this logic in VA.
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.
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.