Product-Specific Details

SAS Procedures

The dependencies between MARKUP and LISTING have been removed. For more information, see "The REPORT Procedure" in the Base SAS Procedures Guide.

The DICTIONARY.EXTFILES table now includes the access method and device type information.
The DESCRIBE TABLE CONSTRAINTS statement will not display the names of password-protected foreign key data set variables that reference the primary key constraint.
The TRANSCODE=NO argument is not supported by some SAS Workspace Server clients. In SAS 9.2, if the argument is not supported, column values with TRANSCODE=NO are replaced (masked) with asterisks (*). Before SAS 9.2, column values with TRANSCODE=NO were transcoded.
References to the DATE, TIME, DATETIME, and TODAY functions in a query are replaced by their equivalent constant values before a query executes.
PUT function optimization is performed on all PUT functions whose query is performed by a SAS/ACCESS engine.
If indexing is present, PROC SQL now uses the index files when processing SELECT DISTINCT statements.
If you use the DBIDIRECTEXE system option, the PROC SQL DELETE statement is sent directly to the database for execution, which could result in CPU and I/O performance improvement.

For more information, see "The SQL Procedure" in Base SAS Procedures Guide.