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
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.
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
See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.
Find more tutorials on the SAS Users YouTube channel.