As of 14Jul2015, updated versions of SAS/ACCESS Relational Database Interfaces are available as part of the SAS 9.4 Maintenance 3 release. This includes interfaces to the following database engines:
There is also a new interface: SAS/ACCESS Interface to HAWQ.
For most database interfaces, you have access to new options (PRE_TABLE_OPTS=, POST_TABLE_OPTS=, PRE_STMT_OPTS=, and POST_STMT_OPTS=) that enable you to modify the automatically generated CREATE TABLE statement.
Enhancements to SAS/ACCESS Interface to Hadoop include:
Enhancements for SAS/ACCESS Interface to Impala include:
Enhancements to SAS/ACCESS Interface to SAP HANA include:
SAS/ACCESS Interface to PostgreSQL automatically passes down the COMPRESS and COT functions from SAS for processing by the PostgreSQL
engine.
SAS/ACCESS Interface to Teradata supports object names that contain up to 32 characters for users with Teradata 14.10 or higher.
SAS/ACCESS Interface to Microsoft SQL Server now supports Microsoft Windows for x86 and Microsoft Windows for x64 platforms.
You can find the complete list of new features and enhancements in “What’s New in SAS/ACCESS 9.4 for Relational Databases.”
Here is a good overview video on SAS/ACCESS interfaces:
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Data Literacy is for all, even absolute beginners. Jump on board with this free e-learning and boost your career prospects.