Solved: Re: Difference between to dates / lag function - SAS Support Communities

🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.

Obsidian | Level 7

Obsidian | Level 7

Difference between to dates / lag function

Posted 02-18-2016 04:28 AM (2278 views)

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.

1 ACCEPTED SOLUTION

Accepted Solutions

Obsidian | Level 7

Obsidian | Level 7

Re: Difference between to dates / lag function

Posted 02-19-2016 03:54 AM (3242 views) | In reply to PeterWijers

Hi again

Thank you. The functionality I had overlooked

Best regards

Jesper

View solution in original post

4 REPLIES 4

Lapis Lazuli | Level 10

Lapis Lazuli | Level 10

Re: Difference between to dates / lag function

Posted 02-19-2016 01:11 AM (2248 views) | In reply to JesperNyholm

Jesper,

Its possible in SAS VA. Try this functionality.

Greetings and succes. Peter

Obsidian | Level 7

Obsidian | Level 7

Re: Difference between to dates / lag function

Posted 02-19-2016 03:54 AM (3243 views) | In reply to PeterWijers

Hi again

Thank you. The functionality I had overlooked

Best regards

Jesper

Obsidian | Level 7

Obsidian | Level 7

Re: Difference between to dates / lag function

Posted 02-22-2016 07:48 AM (2218 views) | 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?

Lapis Lazuli | Level 10

Lapis Lazuli | Level 10

Re: Difference between to dates / lag function

Posted 02-22-2016 09:14 AM (2214 views) | 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