BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
slew
Calcite | Level 5

I created a Library in Management Console called "STUDENT" using an Oracle schema called SATURN. 

 

Recently, I received a request to add an additional table to STUDENT, but the new table is in a different schema called GENERAL.

 

How do I add tables a different schema (GENERAL) to an existing SAS library created from a different schema (SATURN)?

 

Thank you.

1 ACCEPTED SOLUTION

Accepted Solutions
SASKiwi
PROC Star

You can't specify more than one database schema in a SAS data library. A workaround would be to create a view in your current Oracle schema pointing to the table in your second schema.

View solution in original post

2 REPLIES 2
SASKiwi
PROC Star

You can't specify more than one database schema in a SAS data library. A workaround would be to create a view in your current Oracle schema pointing to the table in your second schema.

slew
Calcite | Level 5

Bummer.  That's what I thought, but thank you for confirming.

suga badge.PNGThe SAS Users Group for Administrators (SUGA) is open to all SAS administrators and architects who install, update, manage or maintain a SAS deployment. 

Join SUGA 

Get Started with SAS Information Catalog in SAS Viya

SAS technical trainer Erin Winters shows you how to explore assets, create new data discovery agents, schedule data discovery agents, and much more.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 2 replies
  • 1097 views
  • 2 likes
  • 2 in conversation