Hi @Patrick ,please find below Error in log.please help MPRINT(ETLS_SQL_UPDATE): proc sql;
^L10 The SAS System 16:57 Tuesday, September 17, 2019
NOTE: Line generated by the invoked macro "ETLS_SQL_UPDATE".
308 where W6SZW2W.ID = sasdataset.W6SZW2W.ID
_
22
76
308 ! ) ; quit; %rcSet(&syscc);
MPRINT(ETLS_SQL_UPDATE): update DDD.sasdataset set Source= ( select W6SZW2W.Source length = 30 label =
'Source ' from work.W6SZW2W as W6SZW2W where W6SZW2W.ID =
sasdataset.W6SZW2W.ID ) ;
ERROR 22-322: Syntax error, expecting one of the following: !, !!, &, ), *, **, +, -, /, <, <=, <>, =, >, >=, AND, EQ, EQT, EXCEPT,
GE, GET, GROUP, GT, GTT, HAVING, INTERSECT, LE, LET, LT, LTT, NE, NET, NOT, OR, OUTER, UNION, ^, ^=, |, ||, ~, ~=.
ERROR 76-322: Syntax error, statement will be ignored.
NOTE: PROC SQL set option NOEXEC and will continue to check the syntax of statements.
MPRINT(ETLS_SQL_UPDATE): quit;
NOTE: The SAS System stopped processing this step because of errors.
NOTE: PROCEDURE SQL used (Total process time):
real time 0.00 seconds
user cpu time 0.00 seconds
system cpu time 0.00 seconds
memory 45.59k
OS Memory 8740.00k
Timestamp 17/09/2019 16:57:50 o'clock
Page Faults 3
Page Reclaims 5
Page Swaps 0
Voluntary Context Switches 0
Involuntary Context Switches 2
Block Input Operations 0
Block Output Operations 0
MPRINT(ETLS_SQL_UPDATE): ;
... View more
