That seems to have added an additional error.
Here is the log:
NOTE: Mapping columns ...
5307 proc sql;
5308 create view work.W1PO1ZZ7 as
5309 select
5310 STC_PERSON_ID as STU_ID,
5311 STC_COURSE_NAME,
5312 STC_TERM,
5313 STC_SECTION_NO,
5314 (TRIM(STC_COURSE_NAME)||'*'||TRIM(STC_SECTION_NO)) as STC_CRS_SEC length = 8,
5315 &SYSDATE as SNAPSHOT_DATE length = 8
______
22
76
ERROR 22-322: Syntax error, expecting one of the following: GROUP, HAVING, ORDER, WHERE.
ERROR 76-322: Syntax error, statement will be ignored.
NOTE: Line generated by the macro variable "SYSDATE".
5315 14OCT15
_____
22
ERROR 22-322: Syntax error, expecting one of the following: !, !!, &, *, **, +, ',', -, /, <, <=, <>, =, >, >=, ?, AND, AS,
CONTAINS, EQ, EQT, FROM, GE, GET, GT, GTT, LE, LET, LIKE, LT, LTT, NE, NET, OR, ^=, |, ||, ~=.
5316 from &SYSLAST
5317 where STC_TERM = '15/FA'
5318 ;
NOTE: PROC SQL set option NOEXEC and will continue to check the syntax of statements.
5319 quit;
174 The SAS System 09:27 Wednesday, October 14, 2015
NOTE: The SAS System stopped processing this step because of errors.
And here is a picture of my Extract Transformation Mappings tab:
... View more