What’s New in the SAS 9.3 SQL Procedure
Overview
PROC SQL reference information
from the
Base SAS Procedures Guide and SAS
SQL system options from the
SAS Language Reference: Dictionary have
been moved to this book,
SAS SQL Procedure User’s
Guide. This enables our customers to access PROC SQL information
in one location. The following are new features and enhancements:
-
ability to optimize the PUT function
-
ability to reuse the LIBNAME statement
database connection
-
additional PROC SQL statement options
-
additional macro variable specifications
for the INTO clause
-
additional dictionary table
-
additional system macro variable
-
In the second maintenance
release for SAS 9.3, the following enhancements have been made:
-
modified the default value for
the SQLGENERATION= option
-
added security for password-protected
SAS views
Ability to Optimize the PUT Function
The following reduce
PUT options and system options have been modified to optimize the
PUT function:
Ability to Reuse the LIBNAME Statement Database Connection
The database connection
that is established with the LIBNAME statement can be reused in the
CONNECT statement. The keyword USING has been added to implement this
feature.
Additional PROC SQL Statement Options
The following PROC SQL
statement options have been added to help control execution and output
of results:
-
-
WARNRECURS | NOWARNRECURS
Additional Macro Variable Specifications for the INTO Clause
The following macro
variable specifications have been added to the syntax for the INTO
clause of the SELECT statement:
-
-
unbounded
macro-variable range
Additional Dictionary Table
The VIEW_SOURCES dictionary
table view has been added.
Additional System Macro Variable
The SYS_SQLSETLIMIT
macro variable has been added for use with PROC SQL to improve database
processing.
Updated Output Examples
Where applicable, all
of the LISTING output examples have been updated to show the new ODS
HTML output. The new SAS 9.3 output defaults apply only to the SAS
windowing environment under Microsoft Windows and UNIX.
Modified the Default Value for the SQLGENERATION= Option
The default value for
the SQLGENERATION= LIBNAME option and system option was modified to
include Aster
nCluster and
Greenplum.
Added Security for Password-Protected SAS Views
In the second maintenance
release for SAS 9.3, security has been enhanced for password-protected
SAS views. Before the second maintenance release for SAS 9.3, Read-
or Write-protected SAS views could be defined using the DESCRIBE VIEW
statement without having to specify a password. Now, to define any
password-protected SAS view, regardless of the level of protection,
you must specify a password. If the SAS view was created with more
than one password, you must specify its most restrictive password
if you want to access a definition of the view.
Copyright © SAS Institute Inc. All rights reserved.