BookmarkSubscribeRSS Feed
tjc
Calcite | Level 5 tjc
Calcite | Level 5
If one has a SAS/ACCESS for Teradata/ORACLE/DB2 license for PC SAS, is there a (hopefully easy!) way for an individual to add a LIBNAME for a local connection to allow the Excel Add-In to access external relational databases? Thanks!
1 REPLY 1
Cynthia_sas
Diamond | Level 26
Hi:
Although there is a way in a stored process to issue a LIBNAME statement that bypasses the Metadata Server, I don't generally recommend the practice as a way to access your data. One really fundamental purpose of the SAS Add-in for Microsoft Office is to USE the Metadata (including the data library definitions) in order to allow access and control access to all your data based on userid or group membership.
You should discuss what you want to do with your SAS Administrator and determine whether there was a configuration or security reason why definitions for these DBMS tables were not added to the Metadata.
If your SAS Administrator has not taken the Platform Administration training or has not consulted the Platform Administration documentation, you or the Administrator can consult with Tech Support for more help.

cynthia

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

Register Now

Discussion stats
  • 1 reply
  • 1059 views
  • 0 likes
  • 2 in conversation