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 nicknames
  • 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

These items are new.
  • 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.