topic Counting days in SAS Programming

Counting days

Posterne — Thu, 30 Aug 2018 08:01:00 GMT

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

Re: Counting days

RW9 — Thu, 30 Aug 2018 08:03:10 GMT

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

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

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.

Re: Counting days

Posterne — Thu, 30 Aug 2018 08:14:07 GMT

Thanks! This community is amazing