Dear Communities,
I need to execute a PROC SQL on a table that has a dot in its name (i.e. esign.state is the table name).
I have registered a library that preserve table names with their original names.
LIBNAME DUW ODBC DATAsrc=DUW SCHEMA=gbox;
proc sql;
create table Test_Q1 as
select * from duw.esign.state;
quit;
However, Enterprise Guide gives me the following error:
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.
Do you know any workaround so as to resolve the issue?
Thank you in advance,
Vasilios
... View more