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
You would use the intck function with parameter 'day':
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.
You would use the intck function with parameter 'day':
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.
Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.