difference between 2 dates in MONTHS

[PierreYvesILY]

dear SAS experts,

I need to programm the following difference between 2 dates and test if the difference in months is inferior to 6 months.

I can do this in days, but I can't get the right way to do this in Months (I cannot use standardized months or so, unfortunately)

if (DATE1 - DATE2) < 6   then NewParameter = 1;

how can I correct the (DATE1 - DATE2) expression to get the result in months?

[PeterClemmensen]

The INTCK Function returns the number of interval boundaries between two dates 

data _null_;
    dt1='01jan2019'd;
    dt2='16oct2019'd;

    difmonths=intck('month', dt1, dt2);

    put difmonths=;
run;

[PierreYvesILY]

Danke dir!

[Patrick]

@PierreYvesILY 

If what @PeterClemmensen posted is the solution for you then please mark it as solution so we know you've got your answer. Marking something as solution will also help others who search the forums later on to get answers to similar problems.

[PierreYvesILY]

I always test the solutions proposed before sending an approval.

I just got my tests results and can now close the question.

[Jagadishkatam · Accepted solution]

Please try the intck function

if intck('month', start_date, end_date, 'continuous')<6 then newparameter=1;

[PierreYvesILY]

I implemented this solution, which has been tested now on a range of 200000 cases without any pb.

Thanks!

[ed_sas_member]

Hi @PierreYvesILY ,

I suggest to use the intck() function.

It returns the number of interval boundaries of a given kind, like months.

Hope this help!

data want;
	set have;
	month_dif = intck('month',date1,date2);
run;