Problem Note 46563: WARNING: SQL generation was not performed because the RENAME statement, data set option, or LIBNAME option is not supported
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.
Operating System and Release Information
SAS System | Base SAS | 64-bit Enabled AIX | 9.3 TS1M0 | 9.3 TS1M2 |
64-bit Enabled HP-UX | 9.3 TS1M0 | 9.3 TS1M2 |
64-bit Enabled Solaris | 9.3 TS1M0 | 9.3 TS1M2 |
HP-UX IPF | 9.3 TS1M0 | 9.3 TS1M2 |
Linux | 9.3 TS1M0 | 9.3 TS1M2 |
Linux for x64 | 9.3 TS1M0 | 9.3 TS1M2 |
Solaris for x64 | 9.3 TS1M0 | 9.3 TS1M2 |
*
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
fixed.
If you sort an Oracle table using PROC SORT in SASĀ® 9.3, this message might appear in the SAS log file.
Type: | Problem Note |
Priority: | high |
Date Modified: | 2012-06-11 16:35:26 |
Date Created: | 2012-05-11 17:51:19 |