With the ODBC this definition has been put hidden in the odbc.ini file. With Oracle it is the schema option, with DB2 the SSID. SAS/ACCESS(R) 9.3 for Relational Databases: Reference, Second Edition (odbc start). The connection options can be coded along with SAS statements, this is a list: SAS/ACCESS(R) 9.3 for Relational Databases: Reference, Second Edition (libname odbdc) Samples are there when you click. See the Schema as the first part of that two level naming with tables at databases. As you are needing two different llibname with each an other schema (dsn) the effect will be SAS is copying all data to SAS and executing it there. To prevent that do something with DB-session binding or use explicit SQL pass through. Your error could be indicating you have no access to create tables in that dedicated area. Often the DBA is reserving changing table structures as his task (Data Definition Language)
... View more