Hello
I want to calculate number of months between two dates and keep it as a sas macro variable.
Do you know how to do it in open code?
%let start=1612;
%let end=1803;
%let date_start=%sysfunc(inputn(&start.,yymmn4.));
%let date_end=%sysfunc(inputn(&end.,yymmn4.));
%let n=%sysfunc(intck('QUARTER',&date_start.,&date_end.)) ;
I get warning
WARNING: An argument to the function INTCK referenced by the %SYSFUNC or %QSYSFUNC macro function is out of range.
I know how to do it in non open code:
Data _null_;
n=intck('QUARTER',&date_start.,&date_end.);
Call Symput ('n',n);
run;
%put &n.;
Macro language is text-only, so quotes are not needed around strings:
%let n=%sysfunc(intck(QUARTER,&date_start.,&date_end.)) ;
If you really want to compute number of months between two dates, I would suggest using MONTH instead of QUARTER as the first argument to INTCK.
You would be much safer using four-digit years. System options can affect whether 1803 is interpreted as 201803 or 191803.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.