topic Re: Differences between dates in SAS Visual Analytics

Differences between dates

FilipJ — Mon, 04 Jun 2018 14:13:28 GMT

Hello

How do I get the difference in numbers between two dates?

I have tried using "Difference fro previous period", but It does not work with days?

Please look at Excel spreadsheet column "C"

Thanks

Re: Differences between dates

LinusH — Mon, 04 Jun 2018 14:25:10 GMT

If you just want straight no of days just use minus.

Re: Differences between dates

Kurt_Bremser — Mon, 04 Jun 2018 14:30:13 GMT

SAS stores dates as counts of days (from a given starting point, which is 1960-01-01). The difference in days between two dates can therefore be calculated with a simple subtraction.

Re: Differences between dates

FilipJ — Mon, 04 Jun 2018 14:33:15 GMT

Thanks,

I am very new to SAS va, could you show how?

Re: Differences between dates

FredrikE — Tue, 05 Jun 2018 07:25:48 GMT

I have not got it to work in 7.4 but in 8.2 it works by using relative period and set offset to -1 and using "Inherit".

It works with days, but if you have a gap between the days you will get a missing value.

//Fredrik