Exploring, modeling, predicting and reporting with SAS Visual Analytics and SAS Visual Statistics

Difference between to dates / lag function

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 9
Accepted Solution

Difference between to dates / lag function

Hi

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.


Accepted Solutions
Solution
‎02-22-2016 07:44 AM
Occasional Contributor
Posts: 9

Re: Difference between to dates / lag function

Hi again

Thank you. The functionality I had overlooked

Best regards

Jesper

View solution in original post


All Replies
Regular Contributor
Posts: 172

Re: Difference between to dates / lag function

 Jesper,

Its possible in SAS VA. Try this functionality.

19-02-2016 07-10-11.png

Greetings and succes.  Peter

Solution
‎02-22-2016 07:44 AM
Occasional Contributor
Posts: 9

Re: Difference between to dates / lag function

Hi again

Thank you. The functionality I had overlooked

Best regards

Jesper

Occasional Contributor
Posts: 9

Re: Difference between to dates / lag function

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

Re: Difference between to dates / lag function

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
Post a Question
Discussion Stats
  • 4 replies
  • 563 views
  • 0 likes
  • 2 in conversation