☑ This topic is solved. Need further help from the community? Please sign in and ask a new question.
Calcite | Level 5

## Calculate months between two dates in SAS

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
1 ACCEPTED SOLUTION

Accepted Solutions
Super User

## Re: Calculate months between two dates in SAS

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.

5 REPLIES 5
Super User

## Re: Calculate months between two dates in SAS

Remove the format (YYMMDD) from the macro variables.
Calcite | Level 5

## Re: Calculate months between two dates in SAS

Thanks for your help.
Now it works.

Kind regards,
Ben
Super User

## Re: Calculate months between two dates in SAS

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));``````
Diamond | Level 26

## Re: Calculate months between two dates in SAS

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;``````
--
Paige Miller
Super User

## Re: Calculate months between two dates in SAS

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.

Discussion stats
• 5 replies
• 685 views
• 2 likes
• 5 in conversation