DATA Step, Macro, Functions and more

calculate a time interval using macro variables

Accepted Solution Solved
Reply
Super Contributor
Posts: 318
Accepted Solution

calculate a time interval using macro variables

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?

 


Accepted Solutions
Solution
‎01-14-2016 02:19 PM
Super User
Posts: 5,516

Re: calculate a time interval using macro variables

Posted in reply to fengyuwuzu

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

View solution in original post


All Replies
Solution
‎01-14-2016 02:19 PM
Super User
Posts: 5,516

Re: calculate a time interval using macro variables

Posted in reply to fengyuwuzu

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

Super Contributor
Posts: 318

Re: calculate a time interval using macro variables

[ Edited ]
Posted in reply to Astounding

yes. thanks.
this solved the problem.

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 217 views
  • 0 likes
  • 2 in conversation