topic Numer of months between 2 dates in New SAS User

Numer of months between 2 dates

dee3bee — Wed, 13 Mar 2019 13:26:01 GMT

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

Re: Numer of months between 2 dates

Astounding — Wed, 13 Mar 2019 13:33:47 GMT

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;

n_months = n_days / 365.25 * 12;

Re: Numer of months between 2 dates

LawrenceHW — Wed, 13 Mar 2019 16:10:48 GMT

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