• Print |
• E-mail  |
• Bookmark

When using the SCHEMA= parameter on the CONNECT statement in PROC SQL
Pass-Through code with SAS 9, you will receive the following error:

   ERROR:  Invalid option name schema.

The same code runs without error in SAS 8.

SCHEMA= was never a valid parameter with PROC SQL Pass-Through code. In
SAS 8, SCHEMA= was simply ignored.

In SAS 9, the code has been cleaned up and catches the invalid
parameter, thus causing the ERROR to be written to the log.

To work around the issue, either remove SCHEMA= from the CONNECT
statement, or if possible, use a LIBNAME connection to your database
where SCHEMA= is a valid parameter.

Operating System and Release Information