topic Difference between to dates / lag function in SAS Visual Analytics

Difference between to dates / lag function

JesperNyholm — Thu, 18 Feb 2016 09:28:41 GMT

Is it possible to calculate the difference between to dates in SAS VA 7.3?

I have the number of customers for each month, but needs the monthly growth in customers for each month.

Can it be calculated in SAS VA or need I do it before loading in VA? I do not see that there is a layer function.

Re: Difference between to dates / lag function

PeterWijers — Fri, 19 Feb 2016 06:11:50 GMT

Jesper,

Its possible in SAS VA. Try this functionality.

Greetings and succes. Peter

Re: Difference between to dates / lag function

JesperNyholm — Fri, 19 Feb 2016 08:54:00 GMT

Hi again

Thank you. The functionality I had overlooked

Best regards

Jesper

Re: Difference between to dates / lag function

JesperNyholm — Mon, 22 Feb 2016 12:48:37 GMT

And if I need to know the year to date Growth in number of customers, is that possible within SAS VA?

Re: Difference between to dates / lag function

PeterWijers — Mon, 22 Feb 2016 14:14:46 GMT

Jesper,
only if you first fix the data to count new customers by day.
Within VA doing both calculations (count by day and YTD), not a clue how to do that.
greetings