O'Reilly logo

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

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required