Hello,
I would like to access the available synonyms via odbc.
If I use this code, I get the tables and views, but I can't find the synonyms:
Libname sqlserv ODBC Schema=DBO DSN=sassql;
Proc SQL;
Create Table Work_Cont_Dict As Select * From Dictionary.Tables Where Libname eq UpCase('sqlserv');
Quit;
* proc datasets gives the same result - only views and tables;
Proc Datasets Library=sqlserv;
*Contents Out=Contents Data=_ALL_ Details; * if I remove the comment, it gives me an error;
Run;
How can I get a list of available synonyms?
Thanks&kind regards
If I look through SAS/ACCESS doc, it seems there are only support for synonyms in Netezza and Oracle.
So my guess is that you nedd to use explicit SQL pass-thru to access those.
If I look through SAS/ACCESS doc, it seems there are only support for synonyms in Netezza and Oracle.
So my guess is that you nedd to use explicit SQL pass-thru to access those.
Thanks. I needed something like:
Proc SQL NoPrint;
Connect To ODBC (DSN=sassql);
Create Table Synonyms As Select * From Connection To ODBC
(SELECT * FROM SYS.SYNONYMS) Order By name ;
Disconnect From ODBC;
Quit;
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Need to connect to databases in SAS Viya? SAS’ David Ghan shows you two methods – via SAS/ACCESS LIBNAME and SAS Data Connector SASLIBS – in this video.
Find more tutorials on the SAS Users YouTube channel.