Desktop productivity for business analysts and programmers

Multiple Schemas for Single SAS Library?

Reply
N/A
Posts: 0

Multiple Schemas for Single SAS Library?

I've created a SAS library that uses SAS/ACCESS to connect to an Oracle database. I've been successfull in referencing the library to a single schema, however, I can't get it work with multiple schemas.

Can someone help?
Community Manager
Posts: 2,696

Re: Multiple Schemas for Single SAS Library?

I can only point you toward the SCHEMA= option on the libname statement:

http://support.sas.com/techsup/unotes/SN/002/002733.html
http://support.sas.com/faq/038/FAQ03822.html

A search of SAS Notes for "oracle schema" will yield many other possible hints.

http://support.sas.com/techsup/search/sasnotes.html

Chris
N/A
Posts: 0

Re: Multiple Schemas for Single SAS Library?

Thanks. I'm going to try this out when I get back to the office.
Ask a Question
Discussion stats
  • 2 replies
  • 322 views
  • 0 likes
  • 2 in conversation