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
Get SAS 9.4 SQL Procedure User's Guide, Fourth Edition, 4th Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
