Okay I put the info in as this for an advanced expression. data test; set t2.BEGIN_TIME; time=input(cats(substr(t2.BEGIN_TIME, 1, 2), ':', substr(t2.BEGIN_TIME, 3, 2)), time5.); format time timeampm7.; run; Then I clicked validate and it gave me this back. PROC SQL NOEXEC; SELECT (data test; set t2.BEGIN_TIME; time=input(cats(substr(t2.BEGIN_TIME, 1, 2), ':', substr(t2.BEGIN_TIME, 3, 2)), time5.); format time timeampm7.; run;) AS CALCULATION FROM ODS_OPSU.SCHEDULE_OFFERING t1 INNER JOIN ODS_OPSU.MEETING_TIME t2 ON (t1.COURSE_IDENTIFICATION = t2.COURSE_IDENTIFICATION); QUIT; ;*';*";*/;quit;run; 2 OPTIONS PAGENO=MIN; 3 OPTION DEBUG=DBMS_SELECT SQL_IP_TRACE=(NOTE, SOURCE); 4 PROC SQL NOEXEC; 5 SELECT (data test; ____ 22 76 ERROR 22-322: Syntax error, expecting one of the following: !, !!, &, (, ), *, **, +, -, '.', /, <, <=, <>, =, >, >=, ?, AND, BETWEEN, CONTAINS, EQ, EQT, GE, GET, GT, GTT, IN, IS, LE, LET, LIKE, LT, LTT, NE, NET, NOT, NOTIN, OR, ^, ^=, |, ||, ~, ~=. ERROR 76-322: Syntax error, statement will be ignored. 6 set t2.BEGIN_TIME; __ 22 76 ERROR 22-322: Syntax error, expecting one of the following: MODE, TRANSACTION. ERROR 76-322: Syntax error, statement will be ignored. 7 time=input(cats(substr(t2.BEGIN_TIME, 1, 2), ':', substr(t2.BEGIN_TIME, 3, 2)), time5.); ____ 180 ERROR 180-322: Statement is not valid or it is used out of proper order. 8 format time timeampm7.; WARNING: This SAS global statement is not supported in PROC SQL. It has been ignored. 9 run;) AS CALCULATION _ 180 NOTE: PROC SQL statements are executed immediately; The RUN statement has no effect. ERROR 180-322: Statement is not valid or it is used out of proper order. 10 FROM ODS_OPSU.SCHEDULE_OFFERING t1 11 INNER JOIN ODS_OPSU.MEETING_TIME t2 ON (t1.COURSE_IDENTIFICATION = t2.COURSE_IDENTIFICATION); 12 QUIT; NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE SQL used (Total process time): real time 0.00 seconds cpu time 0.01 seconds 13 %PUT SQL_IPTRACE_RESULT=&SYS_SQL_IP_ALL; SQL_IPTRACE_RESULT=-1 14 OPTIONS SQL_IP_TRACE=(NONE); 15 QUIT; RUN;
... View more