I'm trying to get to a more precise number of months between 2 dates than given by the INTCK function.
For example: INTCK('MONTH','15MAR2018'd,11MAR2019'd) returns 12 even though the difference is less than 12 month (by 4 days).
Is there a way I could return only the number of pull months between 2 dates? Or return a decimal representation of the number of months (11.93) between 2 dates? Thanks
data test;
x=INTCK('MONTH','15MAR2018'd,'11MAR2019'd);
y=INTCK('MONTH','15MAR2018'd,'11MAR2019'd,'C');
run;
This will give Y=11 which is the number of whole months between the 2 dates.
Cheers,
Lawrence
Ready to join fellow brilliant minds for the SAS Hackathon?
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.