Hi i am trying to figure out syntax error i am getting. This is in a data step: Is it from the dosubl or the %finnalload macro being called?
9236
9237 data _null_;
9238 set tables_toload;
9239 put "contact date?";
9240 put contactdtpresent;
9241 put "extenidpresent?";
9242 put externidpresent;
9243 if &loadcnt > 0 then
9244 loadrc = dosubl('%finalload("tablename",contactdtpresent,externidpresent)');
9245 else
9246 put "Nothing to load, no tables passed all validations";
9247 run;
contact date?
0
extenidpresent?
0
ERROR 22-322: Syntax error, expecting one of the following: (, AS, LIKE.
ERROR 200-322: The symbol is not recognized and will be ignored.
ERROR 79-322: Expecting a ).
ERROR 76-322: Syntax error, statement will be ignored.
ERROR 22-322: Syntax error, expecting one of the following: (, SELECT, SET, VALUES.
ERROR 200-322: The symbol is not recognized and will be ignored.
ERROR 22-322: Syntax error, expecting one of the following: ;, VALUES.
ERROR 76-322: Syntax error, statement will be ignored.
ERROR 22-322: Syntax error, expecting one of the following: ;, (, ',', INDEX, TABLE, VIEW.
ERROR 200-322: The symbol is not recognized and will be ignored.
ERROR 22-322: Syntax error, expecting one of the following: a name, ;, (, ',', ANSIMISS, AS, CROSS,
EXCEPT, FULL, GROUP, HAVING, INNER, INTERSECT, JOIN, LEFT, NATURAL, NOMISS, ORDER,
OUTER, RIGHT, UNION, WHERE.
ERROR 200-322: The symbol is not recognized and will be ignored.
ERROR 22-322: Syntax error, expecting one of the following: a name, (, ), ',', ANSIMISS, AS, CROSS,
EXCEPT, FULL, GROUP, HAVING, INNER, INTERSECT, JOIN, LEFT, NATURAL, NOMISS, OUTER,
RIGHT, UNION, WHERE.
ERROR 200-322: The symbol is not recognized and will be ignored.
ERROR 22-322: Syntax error, expecting one of the following: a name, (, ), ',', ANSIMISS, AS, CROSS,
EXCEPT, FULL, GROUP, HAVING, INNER, INTERSECT, JOIN, LEFT, NATURAL, NOMISS, OUTER,
RIGHT, UNION, WHERE.
ERROR 200-322: The symbol is not recognized and will be ignored.
ERROR 180-322: Statement is not valid or it is used out of proper order.
NOTE: The SAS System stopped processing this step because of errors.
NOTE: PROCEDURE SQL used (Total process time):
real time 0.87 seconds
cpu time 0.04 seconds
... View more