topic Re: Calculate months between two dates in SAS in SAS Programming

Calculate months between two dates in SAS

BenEntrew — Tue, 20 Jun 2023 18:49:31 GMT

Hi all,
somehow I can't calculate the months between 20211231 and 20230228.

Code:Copy to clipboard
%let End = %sysfunc(intnx(month,%sysfunc(today()),-4,e),YYMMDDN8.);
%let Begin = %sysfunc(intnx(year, %sysfunc(date()), -2, e),YYMMDDN8.);
%put &Begin;
%put &End;

%let count_months =%sysfunc(intck(month,&Begin.,&End.));
%put &count_months;

I get the following log statement:
WARNING: An argument to the function INTCK referenced by the %SYSFUNC or %QSYSFUNC macro function is out of range.
NOTE: Mathematical operations could not be performed during %SYSFUNC function execution.
The result of the operations have been set to a missing value.

Can someone help me with synthax?

Many thanks in advance.

Kind regards,
Ben

Re: Calculate months between two dates in SAS

Reeza — Tue, 20 Jun 2023 19:05:23 GMT

Remove the format (YYMMDD) from the macro variables.

Re: Calculate months between two dates in SAS

Kurt_Bremser — Tue, 20 Jun 2023 19:05:47 GMT

A SAS date value is an integer count of days, starting at 1960-01-01.

So the number 20211231 would be very far in the future, beyond the range of available formats.

Maxim 28: Macro Variables Need no Formats.

%let End = %sysfunc(intnx(month,%sysfunc(today()),-4,e));
%let Begin = %sysfunc(intnx(year,%sysfunc(today()),-2,e));

Re: Calculate months between two dates in SAS

PaigeMiller — Tue, 20 Jun 2023 19:06:47 GMT

DO NOT format macro variables. This prevents mathematical operations from working correctly.

Use unformatted macro variables

%let End = %sysfunc(intnx(month,%sysfunc(today()),-4,e));
%let Begin = %sysfunc(intnx(year, %sysfunc(date()), -2, e));
%put &Begin;
%put &End;

%let count_months =%sysfunc(intck(month,&Begin.,&End.));
%put &count_months;

Re: Calculate months between two dates in SAS

ballardw — Tue, 20 Jun 2023 19:06:57 GMT

Don't apply the format when creating the value, that changes the values that INTCK expects to see.

When you formatted the value you changed a numeric value on the order of 23181 to 20230620. INTCK and other date functions in SAS expect to see a value that is the number of days since 01JAN1960 as an argument. So the formatted value such as 20230620 would be roughly in year 55,388. The SAS date functions won't work with any dates past the year 20,000 .

If you have a need for a formatted version of Begin and End then create separate non-formatted variables.

Re: Calculate months between two dates in SAS

BenEntrew — Wed, 21 Jun 2023 09:00:28 GMT

Thanks for your help.
Now it works.

Kind regards,
Ben