Hi, I'm trying to find two time variable difference using below query. but it is throwing me the following error. Can someone let me know what mistake I did. Please help me. QUERY: PROC SQL; CREATE TABLE WIS.TEMP7 AS SELECT INTCK('MINUTE', 'MAX_TIME'T, 'MIN_TIME'T) FROM ( SELECT MAX(TIME) AS MAX_TIME, MIN(TIME) AS MIN_TIME,FILEID, DT FROM MTG.LOGFILE_WIS_FINAL_UI5_FINAL GROUP BY FILEID, DT); Result: 5 PROC SQL; 16 CREATE TABLE WIS.TEMP7 AS 17 SELECT INTCK('MINUTE', 'MAX_TIME'T, 'MIN_TIME'T) FROM ( ERROR: Invalid date/time/datetime constant 'MAX_TIME'T. ERROR: Invalid date/time/datetime constant 'MIN_TIME'T. 18 SELECT MAX(TIME) AS MAX_TIME, MIN(TIME) AS MIN_TIME,FILEID, DT FROM 18 ! MTG.LOGFILE_WIS_FINAL_UI5_FINAL GROUP BY FILEID, DT); but the table is getting created using second query.
... View more
