SAS 9.4 SQL Procedure User's Guide, Fourth Edition, 4th Edition

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.

xiv SQL Procedure