What's New in SAS/ACCESS 9.3 for Relational Databases
Overview
SAS/ACCESS 9.3 for
Relational Databases has these new features and enhancements.
-
new
SAS/ACCESS Interface to Hadoop
in March 2012
-
updated operating environments
for various
SAS/ACCESS interfaces
-
-
new function and options for the
Teradata interface
-
documentation enhancements
Operating Environments Updates
Operating environments
for specific
SAS/ACCESS interfaces have changed. See
SAS/ACCESS Features
by Host for the operating environments that your interface supports.
New Nicknames
These interfaces have
new nicknames.
-
SAS/ACCESS Interface to Aster
nCluster:
aster
-
SAS/ACCESS Interface to Greenplum:
greenplm
-
SAS/ACCESS Interface to Sybase
IQ:
sybaseiq
Second Maintenance Release for SAS 9.3: General Changes
In the second maintenance
release for SAS 9.3, the default value for the SQLGENERATION= LIBNAME
and system options includes Aster
nCluster
and Greenplum.
SAS/ACCESS Interface to Aster nCluster
In the second maintenance
release for SAS 9.3, the default PORT= number for the LIBNAME statement
has changed.
SAS/ACCESS Interface to Hadoop
In the March 2012 release
for SAS 9.3,
SAS/ACCESS Interface to Hadoop is a new database engine.
It provides direct, transparent access to Apache Hadoop through LIBNAME
statements and the SQL pass-through facility. You can use various
LIBNAME statement options and data set options that the LIBNAME engine
supports to control the data that is returned to SAS.
For details about SAS
interfaces to Hadoop, see these topics or documents.
-
SAS/ACCESS Interface to Hadoop
-
SAS/ACCESS Interface to Hadoop:
Supported Features
-
PROC HADOOP in
Base SAS Procedures Guide
-
FILENAME statement (file access
method) in
SAS Statements: Reference
In the second maintenance
release for SAS 9.3, these items are new or enhanced.
-
You can specify a Hadoop
configuration file in a CONNECTION statement or as a connection option
in the LIBNAME statement.
-
DBCREATE_TABLE_EXTERNAL=
LIBNAME and data set options are new.
-
The DBCREATE_TABLE_LOCATION=
data set option is new.
-
DBCREATE_TABLE_OPTS=
LIBNAME and data set options are new.
-
The LENGTH and TRIMN
functions are now automatically passed down by default.
SAS/ACCESS Interface to Oracle
In the second maintenance
release for SAS 9.3, these items are new.
-
DB_OBJECTS= LIBNAME
option
-
OR_BINARY_DOUBLE= LIBNAME
option
SAS/ACCESS Interface to Teradata
-
Temporal qualifiers let you specify
time-dimension criteria for retrieving data from Teradata. For details,
see the section about temporal data types, including how to use them
in a LIBNAME statement or a DATA step.
-
Using the DBCONSTRAINT= data set
option, you can specify with table-level definitions where to create
a table.
In the second maintenance
release for SAS 9.3, these items are new or enhanced.
-
The enhanced LOGDB= LIBNAME option
now also works with the TPT API.
-
The SLEEP= and TENACITY= data set
options are enhanced, and corresponding SLEEP= and TENACITY= LIBNAME
options are new.
-
The new TR_ENABLE_INTERRUPT= LIBNAME
option lets you cancel an executing Teradata query.
Documentation Enhancements
This document includes
these changes.
-
SAS In-Database information is
now in the
SAS In-Database Products: Administrator’s
Guide and the
SAS In-Database Products: User's
Guide. See also the In-Database Processing with
SAS/ACCESS
topic.
-
For the MySQL interface, you can
use the RESULTS= LIBNAME option to specify where you want to store
query results.
Copyright © SAS Institute Inc. All rights reserved.