BookmarkSubscribeRSS Feed
Quartz | Level 8

Dear All,


We are facing issues while migrating sas 9.3 to 9.4. We are able to connect to the oracle without any error. However unable to see the oracle libraries in SAS EG.


FYI... All other libraries I can see on SAS EG.


Quartz | Level 8

Can anyone please update on this?

Super User Tom
Super User

What is an Oracle library?

Do you mean that your previous installation you had defined some SAS librefs that were automatically created when Enterprise Guide started a new SAS session on your SAS application server?

If so then recreate that on your new setup.

Quartz | Level 8

We have defined the oracle library in sas metadata again and also registered the tables after new setup. I can see a list of tables under oracle lib in metadata.


SAS libname name assigned to oracle lib without any error and when I clicked on lib I can't see any tables listed in sasapp server.


Lapis Lazuli | Level 10

You need to make sure your Oracle library has ReadMetadata and Read permissions granted to SASUSERS - those SAS users who are registered in the Metadata.


Available on demand!

Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.


Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 4 replies
  • 3 in conversation