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

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

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