calculate a time interval using macro variables

fengyuwuzu — Thu, 14 Jan 2016 19:03:14 GMT

data WORK.Time    ;
      infile 'Data.csv' delimiter = ',' MISSOVER DSD lrecl=32767 firstobs=2 ;
          format StartTime datetime. ;
          format ClosingTime datetime. ;
      input
            ID $12.
            StartTime :YMDDTTM.
            ClosingTime :YMDDTTM.
            Fee 
            time=INTCK('minute',ClosingTime,StartTime);
     run;

I tried to use the above code to input two time variables and calculate the interval between them. The time format was like

2014-01-01 02:56:37 and after reading into SAS, it is like 01JAN14:02:56:37

when I use

time=INTCK('minute',ClosingTime,StartTime);

but the INTCK function gave error:

ERROR 22-322: Syntax error, expecting one of the following: a name, arrayname, _ALL_, _CHARACTER_,
_CHAR_, _NUMERIC_.

ERROR 76-322: Syntax error, statement will be ignored.

when I use

   time = ClosingTime-StartTime;

RROR: Missing numeric suffix on a numbered variable list (ClosingTime-StartTime).

any hints?

Re: calculate a time interval using macro variables

Astounding — Thu, 14 Jan 2016 19:06:09 GMT

Are you missing the semicolon at the end of the INPUT statement?

Re: calculate a time interval using macro variables

fengyuwuzu — Thu, 14 Jan 2016 19:20:30 GMT

yes. thanks.
this solved the problem.

topic calculate a time interval using macro variables in SAS Programming

calculate a time interval using macro variables

Re: calculate a time interval using macro variables

Re: calculate a time interval using macro variables