I take it SMC is SAS Management Console? I will be a business user but I have to assume the responsibility of an IT administrator due to the lack of resources.
I looked up SMC on their website, it says it manages library and server definitions, and metadata repositories. I opened up SMC but not sure how to add libraries from an external Oracle database.
Our data access engine is SAS/Access ODBC, what I did in Base SAS was I went to "Tools" and "New Library", and added a few libraries through SAS ODBC connecting to external Oracle databases defined under Windows ODBC Administrator on my local machine. The result is whenever I launch a new session the added libraries are always there and I can access all the tables in them.
From your response it seems this change will not be carried over to EG, and we need to use SMC or run codes in EG to accomplish what I did in Base SAS. Can you show me both ways? Where do you run the libname statement in EG and would it be similar to the syntax below? I need the added the libraries to stick whenever I launch new sessions or projects. Thanks for your help!
-- libname databasename odbc dsn=xxx
... View more