questions about converting time into month

[superbug]

I want to convert time between to time points into month. if using (date2 - date1)/30, that doesn't take into account of months that have 31 days. what's the quick way of taking to account of month that have 30 and 31 days?

thank you!

[novinosrin]

I am guessing what you prolly need is to use INTCK function to get the count of monthly intervals between 2 dates

intck('month',date1,date2,'c');

/*or*/

intck('month',date1,date2);

  A small test to understand

%let date1='29dec2019'd;
%let date2='05jan2020'd;

data test;
 month_discrete=intck('month',&date1,&date2);
 month_continuous=intck('month',&date1,&date2,'c');
run;

[superbug]

@novinosrin  

you are always so helpful! Give you a BIG thumb up!

Yes, that worked! 

[mkeintz]

Then mark this topic as solved. It makes it easier for everybody to know in advance which topics are solved and which are not.