## Difference between to dates / lag function

Solved
Occasional Contributor
Posts: 9

# 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

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.

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