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

是 否 +2 论坛币

k人 参与回答

经管之家送您一份

应届毕业生专属福利!

求职就业群

赵安豆老师微信：zhaoandou666

经管之家联合CDA

送您一个全额奖学金名额~ !

立即领取

感谢您参与论坛问题回答

经管之家送您两个论坛币！

+2 论坛币

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

SAS 9.4 SQL Procedure User's Guide 4th Edition.pdf (4.04 MB)

2017-8-5 11:16:10 上传

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.

扫码加我 拉你入群

请注明：姓名-公司-职位

以便审核进群资格，未注明则拒绝

分享0 收藏2 回帖

关键词：Procedure Edition fourth editio dition SAS SQL

neuroexplorer 发表于 2017-8-5 11:17
SAS 9.4 SQL Procedure User's Guide, Fourth Edition (2016)

差评，倒卖官方免费ug

直接在Bing上面搜题目就有得下载了
楼主论坛币都1万8千多了，还收费啊...