Exploring, 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

Posted in reply to PeterWijers

Hi again

Thank you. The functionality I had overlooked

Best regards

Jesper

View solution in original post


All Replies
Regular Contributor
Posts: 191

Re: Difference between to dates / lag function

Posted in reply to JesperNyholm

 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

Posted in reply to PeterWijers

Hi again

Thank you. The functionality I had overlooked

Best regards

Jesper

Occasional Contributor
Posts: 9

Re: Difference between to dates / lag function

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

Re: Difference between to dates / lag function

Posted in reply to JesperNyholm
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
🔒 This topic is solved and locked.

Need further help from the community? Please ask a new question.

Discussion stats
  • 4 replies
  • 1070 views
  • 0 likes
  • 2 in conversation