SAS 9.4 SQL Procedure User's Guide, Fourth Edition (2016)

What's New in the SAS 9.4 SQL Procedure

Overview

Here are the new features and enhancements:

• additional SAS SQL system option and PROC SQL statement options

• support added for extended attributes in DICTIONARY tables

• replaced BUFFERSIZE PROC SQL statement option

• support added for the SQLXOPENERRS macro variable

Additional SAS SQL System Option and PROC SQL Statement Options

The following SQL options have been added to enable PROC SQL to terminate an SQL query if an implicit pass-through request fails:

• SQLIPONEATTEMPT system option

• IPONEATTEMPT | NOIPONEATTEMPT PROC SQL statement options

• in the third maintenance release for SAS 9.4, DICTDIAG | NODICTDIAG PROC SQL statement options

For more information, see “SQLIPONEATTEMPT System Option” on page 377 and “PROC SQL Statement” on page 221.

Support Added for Linguistic Collation

Support has been added for linguistic collation with the SORTSEQ statement option. For more information, see “SORTSEQ=sort-table | LINGUISTIC” on page 229.

xiii

xiv SQL Procedure

Support Added for Extended Attributes in DICTIONARY Tables

Support has been added to copy extended attribute information in DICTIONARY tables. The XATTRS DICTIONARY table and Vxattr Sashelp view have been added. For more information, see “Accessing SAS System Information By Using DICTIONARY Tables” on page 149.

Replaced BUFFERSIZE PROC SQL Statement Option

The BUFFERSIZE option for the PROC SQL statement has been replaced with the UBUFSIZE option. The BUFFERSIZE option that was used prior to SAS 9.4 works the same as the UBUFSIZE option and is still supported. As of SAS 9.4, UBUFSIZE is the preferred option. For more information, see “PROC SQL Statement” on page 221.

Support Added for the SQLXOPENERRS Macro Variable

In the third maintenance release for SAS 9.4, the SQLXOPENERRS macro variable contains the number of DICTIONARY tables that failed to open. For more information, see “SQLXOPENERRS” on page 163.