I've used the following code to calculate months between two date variables, however, I feel like it's not as accurate as I'd like it to be...
data readms_dist2; set readms_dist2;
Months_btwn_adms=intck('month', PRV_DC_DT, ADM_DT); Weeks_btwn_adms=intck('week', PRV_DC_DT, ADM_DT); Days_btwn_adms=intck('day', PRV_DC_DT, ADM_DT);
run;
From my understanidng, the intck month function just counts if the date has "crossed" into the next month -
So if had a PRV_DC_DT was january 1 2020 and the ADM_DT was january 30 2020, then the function would return 0.
but if PRV_DC_DT was january 30 2020 and ADM_DT was february 1 2020 then the function would return 1. This is correct right? Well, that's not very accurate in calculating how many months between two dates, so what's my best option?
Thanks!
... View more