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
April 27 – 30 | Gaylord Texan | Grapevine, Texas
Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!
Still thinking about your presentation idea? The submission deadline has been extended to Friday, Nov. 14, at 11:59 p.m. ET.
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.