ODBC Connection to SSMS. Schema Question

[mcook]

I am connecting to SSMS via ODBC using the following code

libname mylib odbc noprompt = "driver = ODBC Driver 11 for SQL Server;
                             server = Server_Name;
                             database = Database_Name;
                             Trusted_Connection = yes"
                 schema = Schema1;

If i'm only interested in the tables in schema1, schema2 and schema3,

is it possible to get all 3 schemas into one library?  or am i limited to having an individual library for each schema?  

[ChrisNZ · Accepted solution]

You can create  a compound library.

libname LIB1 odbc ... schema = Schema1;
libname LIB2 odbc ... schema = Schema2;
libname LIB3 odbc ... schema = Schema3;
libname LIB4 (LIB1 LIB2 LIB3);