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

Dear Community, I am facing the following problem: given a specific folder and zip filename, I need to unzip the file using Data Integration Studio. In order to achieve this, I have created the following test flow as displayed below.     In the first component I have created a dataset via User Written component with three attributes: The path of the file in which the zip file is included The filename along with the path And the zip file which is basically only the name of the zip file   The code for your convenience is as follows: DATA PARAMS; FILEPATH = 'D:\My_Input'; FILENAME = 'D:\My_Input\My_File_V2_20210201.zip'; ZIP = SCAN(FILENAME, 3, '\'); RUN; DATA &_OUTPUT1; SET WORK.PARAMS; RUN; Then I try to unzip the file via the "X" command as follows: I create two macro variable and I bind the values of the dataset I write the output in the console I perform the unzip command, just as I would normally do via the command prompt DATA _null_; set &_INPUT1; call symputx('pFilepath',strip(Filepath)); call symputx('pZipname',strip(ZIP)); RUN; %put &pZipname; %put %sysfunc(length(&pZipname)); x "cd &pFilepath"; x ' "c:\Program Files\7-Zip\7z.exe" x &pZipname '; What I have noticed is that when I hardcoded the values and execute the flow, the unzip mechanism works. When I try to execute the same with the macro variables it fails.   For your convenience below you will find the hardcoded script which works. x "cd D:\My_Input"; x '"c:\Program Files\7-Zip\7z.exe" x My_File_V2_20210201.zip'; Any suggestion, is highly appreciated.   Best Regards, Vasileios ... View more