Numer of months between 2 dates

[dee3bee]

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

[Astounding · Accepted solution]

It's probably most accurate to compute number of days:

n_days = '11MAR2019'd - '15MAR2018'd;

Then you can convert that using any formula that you want, such as:

n_months = n_days / 30.25;

or

n_months = n_days / 365.25 * 12;

[LawrenceHW]

Try using the 'C' modifier to the INTCK function:

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