Hi. The links are not available anymore (it is an old queistion). Could you provide more detailed? In particular I am interested in solving the following problem. I am able to create a SAS library per schema in SQL Server with LIBNAME ODBC...Statements like this: LIBNAME SchemaA ODBC schema="SchemaA" noprompt="xxx"; LIBNAME SchemaB ODBC shema="SchemaB" noprompt="xxx"; My idea is then to concatinate the created libriries in a SAS library named "database" as follows: libname database (SchemaA SchemaB); However, I have there a problem: Tables with the same names (but different contents) exist in both schemas. How can I solve this issue? PROC DATASET CHANGE is not an option, as I am not allowed to change table names on the SQL server.
... View more