topic Re: How to create lag and lead values in SAS Visual Analytics

How to create lag and lead values

anuragraishines — Tue, 11 Jun 2019 18:16:23 GMT

Hi All,

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.

Regards,

Anurag

Re: How to create lag and lead values

ehmsoleil — Mon, 17 Jun 2019 23:10:35 GMT

Can you please be a little more specific and/or give an example of what you're trying to do?

Re: How to create lag and lead values

SASKiwi — Tue, 18 Jun 2019 07:36:51 GMT

An alternative approach could be to add a lag and lead column to each row of your source data before loading into your LASR server, then calculate aggregates from these.

Re: How to create lag and lead values

anuragraishines — Tue, 18 Jun 2019 09:19:29 GMT

Hi,

e.g.

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.

Regards,

Anurag Rai

Re: How to create lag and lead values

SASKiwi — Tue, 18 Jun 2019 20:13:04 GMT

You can run normal SAS code on SAS VA 7.x to add lag and lead columns to your data before loading into your LASR library. This could be done as part of a batch job which also loads your LASR data.

Re: How to create lag and lead values

anuragraishines — Sun, 23 Jun 2019 19:52:13 GMT

Hi,

We don't have access to reporting layer else it would have been lot easy to achieve.

Anyways thanks for the replies.

Regards,

Anurag Rai

Re: How to create lag and lead values

SASKiwi — Sun, 23 Jun 2019 20:07:12 GMT

I'm not referring to the reporting layer, I'm talking about the data being loaded into your LASR server. Not being able to change your data sourcing if your requirements change doesn't make any sense to me.

Re: How to create lag and lead values

anuragraishines — Sun, 23 Jun 2019 20:35:04 GMT

Hi,

I got stuck in a weird situation don't have any control on data part. SAS Data builder option is also not provided.

Regards,

Anurag

Re: How to create lag and lead values

SASKiwi — Sun, 23 Jun 2019 22:55:47 GMT

You can use SAS Studio in SAS VA to run SAS code to prepare SAS data for loading into your LASR library. Trying to do everything in formulas / calculated measures is severely limiting as well as often being inefficient.