The following message might appear in the SAS log file when you sort a DBMS table using the SORT procedure in SAS^® 9.3:

WARNING: SQL generation was not performed because the RENAME statement, data set option, or LIBNAME option is not supported.

In SAS 9.3, the default behavior of SAS has been changed to take advantage of in-database processing. The default value for the SQLGENERATION option is DBMS. The warning message occurs when SQL generation is not available. However, the SORT procedure sorts the table successfully.

To prevent the warning message from appearing in the SAS log, disable in-database processing by setting the value of the SQLGENERATION option to NONE. Alternatively, disable in-database processing for a particular engine and/or procedure by setting the SQLGENERATION system option appropriately. The SQLGENERATION option can be set as a LIBNAME option or as a SAS system option.

In a future release, the message will be printed as a NOTE. An additional message will clarify that PROC SORT has sorted the table successfully.