topic Re: How Do I Add Tables from a Different Schema to an Existing SAS Library? in Administration and Deployment

How Do I Add Tables from a Different Schema to an Existing SAS Library?

slew — Wed, 18 Sep 2019 19:51:49 GMT

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.

Re: How Do I Add Tables from a Different Schema to an Existing SAS Library?

SASKiwi — Wed, 18 Sep 2019 20:05:35 GMT

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.

Re: How Do I Add Tables from a Different Schema to an Existing SAS Library?

slew — Mon, 23 Sep 2019 16:10:31 GMT

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