topic difference between 2 dates in MONTHS in New SAS User

difference between 2 dates in MONTHS

PierreYvesILY — Wed, 16 Oct 2019 11:08:33 GMT

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?

Re: difference between 2 dates in MONTHS

PeterClemmensen — Wed, 16 Oct 2019 11:12:57 GMT

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;

Re: difference between 2 dates in MONTHS

Jagadishkatam — Wed, 16 Oct 2019 11:13:20 GMT

Please try the intck function

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

Re: difference between 2 dates in MONTHS

ed_sas_member — Wed, 16 Oct 2019 11:14:18 GMT

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;

Re: difference between 2 dates in MONTHS

PierreYvesILY — Wed, 16 Oct 2019 11:27:43 GMT

Danke dir!

Re: difference between 2 dates in MONTHS

Patrick — Wed, 16 Oct 2019 11:57:04 GMT

@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.

Re: difference between 2 dates in MONTHS

PierreYvesILY — Wed, 16 Oct 2019 11:55:36 GMT

I always test the solutions proposed before sending an approval.

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

Re: difference between 2 dates in MONTHS

PierreYvesILY — Wed, 16 Oct 2019 13:04:04 GMT

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

Thanks!