Counting days

[Posterne]

Hi All,

I'm currently trying to write a script that will help me bill people staying at some appartments. I am only billing for one month at a time, so i have set a first day of interest and a last day of interest. What I'm struggling with, is billing those who haven't stayed the full month. How do i count the days between first day of interest and last day of interest when some people have moved in after first day and some have moved out before last day (and even some have done both)?

Thanks in advance

[RW9 · Accepted solution]

You would use the intck function with parameter 'day':

http://support.sas.com/documentation/cdl/en/lefunctionsref/63354/HTML/default/viewer.htm#p1md4mx2crz...

or if your two dates are numeric dates, then subtracting the smaller from the larger will result in the days difference, as SAS stores dates as number of days since the cuttoff point.

[Posterne]

Thanks! This community is amazing