topic Re: Use INTCK in open code in SAS Programming

Use INTCK in open code

Ronein — Mon, 09 Jul 2018 05:21:58 GMT

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

Kurt_Bremser — Mon, 09 Jul 2018 05:56:56 GMT

Macro language is text-only, so quotes are not needed around strings:

%let n=%sysfunc(intck(QUARTER,&date_start.,&date_end.)) ;

Astounding — Mon, 09 Jul 2018 14:08:28 GMT

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.