topic Re: INTCK in SYSFUNC error in SAS Programming

INTCK in SYSFUNC error

SPR — Sun, 27 Mar 2022 15:34:37 GMT

%SYSFUNC(INTCK("Second",&t1,&t2) generates error but INTCK in a data step works fine.

%let t1=%SYSFUNC(DateTime());

%let t2=%SYSFUNC(DateTime());

%let t=%SYSFUNC(INTCK("Second",&t1,&t2));

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.

%put &=t1 &=t2 &=t;

LOG:

/*T1=1963997617.86803 T2=1963999438.99399 T=.*/

data a;
t=INTCK("Second",&t1,&t2);
run;

/* dataset a */

/*t */
/*1821 */

Re: INTCK in SYSFUNC error

ChrisHemedinger — Sun, 27 Mar 2022 15:39:17 GMT

When using %sysfunc, which is a SAS macro construct, you don't enclose literal arguments to functions in quotes.

%let t1=%SYSFUNC(DateTime()); %let t2=%SYSFUNC(DateTime()); %let t=%SYSFUNC(INTCK(Second,&t1,&t2));

Confusing...perhaps. But it's just how SAS macro works as a text generator.

Re: INTCK in SYSFUNC error

Tom — Sun, 27 Mar 2022 15:45:25 GMT

Datetime values are numbers of seconds. So why bother with INTCK() to get the difference in seconds you can just subtract the values.

%let duration=%sysevalf(&t2-&t1);

Re: INTCK in SYSFUNC error

SPR — Mon, 28 Mar 2022 12:31:40 GMT

If this WARNING/NOTE message said "drop apostrophes in the first argument" or "error in the first argument", it will be much more useful that this lengthy text.

Re: INTCK in SYSFUNC error

Tom — Mon, 28 Mar 2022 13:15:04 GMT

Not sure how %SYSFUNC() is supposed to read your mind. I think it is pretty much just echoing the same error as would be generated if you passed an invalid value in a data step.

10    %put %sysfunc(intck('month',1,2));
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.
.
11    %put %sysfunc(intck(fred,1,2));
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.
.
12
13    data _null_;
14      x=intck("'month'",1,2);
15      x=intck("fred",1,2);
16    run;

NOTE: Invalid argument to function INTCK('''month''',1,2) at line 14 column 5.
NOTE: Invalid argument to function INTCK('fred',1,2) at line 15 column 5.
x=. _ERROR_=1 _N_=1
NOTE: Mathematical operations could not be performed at the following places. The results of the operations have been set to missing
      values.
      Each place is given by: (Number of times) at (Line):(Column).
      1 at 14:5   1 at 15:5
NOTE: DATA statement used (Total process time):
      real time           0.01 seconds
      cpu time            0.00 seconds

Re: INTCK in SYSFUNC error

SPR — Mon, 28 Mar 2022 17:22:48 GMT

I do not think that is too difficult to identify what argument contains an issue.