I have a SQL Server Table with special character in its name. For eg: John&Smith_pvt. I want to fetch data from this table into a SAS data set using PROC SQL but I'm getting error and error states " ERROR: CLI describe error: [SAS][ODBC SQL Server Wire Protocol driver][Microsoft SQL Server]Incorrect syntax near '&'. : [SAS][ODBC SQL Server Wire Protocol driver][Microsoft SQL Server]Statement(s) could not be prepared." Code I'm using: proc sql; connect to sqlsvr (dsn="John&Smith_pvt" user=&uid pass=&password); CREATE TABLE Product AS SELECT * FROM connection to sqlsvr (select SUM(UNITS) AS UNITS from John&Smith_pvt ); quit; Solutions I've tried: 1) %let tb_nm = %nrstr(John&Smith);, however macro variable %put &tb_nm is resolving correctly but it is not resolving again in my above mentioned table name. 2) I have also tried libname options, Preserve_tab_name = Yes . eg: libname abc sqlsvr dsn="ProductUnits" uid=&uid. pwd=&password schema= DBO; but no luck error is same as above mentioned. Shout out to SAS expertise..!! Could you please help me out in resolving this error? Thank you in advance.
... View more