SAS/ACCESS®

Providing data access to more of your data sources so you can make better decisions faster. These interfaces are out-of-the-box solutions that provide enterprise data access and integration between SAS and third-party databases. SAS/ACCESS interfaces enable your SAS solutions to read, write, and update data no matter what native databases or platforms you use.  

white marble texture

The most recent release is SAS 9.4M6 and SAS Viya 3.4.

SAS/ACCESS Interfaces and Availability to SAS Viya

The following SAS/ACCESS interfaces have associated data connectors that enable you to load data directly to the CAS server in SAS Viya:

Amazon RedshiftODBC
DB2 under UNIXOracle
*NEW  Google BigQuery PC Files
HadoopPostgreSQL
ImpalaSAP Hana
JDBCSAP Hana
Microsoft SQL Server*NEW  Snowflake 
MySQLVertica
 
These SAS/ACCESS interfaces are integrated with SAS Viya, although there is currently not an associated data connector:  
 

Greenplum
HAWQ
Netezza
R/3
SAP ASE

SAS/ACCESS Interfaces to Nonrelational Databases and Other Data Sources

These SAS/ACCESS interfaces are available for nonrelational databases and other data sources:

NEW! MongoDB
PI System
NEW! Salesforce

Additional Resources for SAS Interfaces to Hadoop

Enhancements for SAS/ACCESS for Relational Databases

  • In the August 2019 release of SAS/ACCESS, support was added for these interfaces:
    • Google BigQuery
    • Snowflake
  • In SAS 9.4M6, support was added for these features: 
    • JDBC interface on SAS 9.4
    • Bulk unloading support for Amazon Redshift
    • Server-side encryption for bulk loading or bulk unloading for Amazon Redshift
  • In SAS Viya 3.4, support was added for these features:
    • JDBC interface and data connector
    • MySQL data connector
    • ODBC and PostgreSQL support on the 64-bit Windows platform
    • Spark interface and data connector (limited availability)
    • Vertica data connector
  • In SAS Viya 3.3, support was added for these features:
    • Data connectors for DB2 under UNIX, Impala, Microsoft SQL Server, ODBC, Oracle, SAP HANA, and Teradata interfaces
    • Integration between SAS Viya and Greenplum, Netezza, MySQL, and SAP ASE interfaces
  • In SAS Viya 3.2, integration was added between SAS Viya and Hadoop.
  • In the April 2016 release of SAS/ACCESS on SAS 9.4M4, support was added for these features:
    • Amazon Redshift interface
    • Netezza on the 64-bit Solaris platform
  • In SAS 9.4M4, the following changes or enhancements were made:
    • SAS/ACCESS Interface to Sybase became SAS/ACCESS Interface to SAP ASE.
    • SAS/ACCESS Interface to Sybase IQ became SAS/ACCESS Interface to SAP IQ.
  • In SAS 9.4M3, support was added for these features:
    • HAWQ interface
    • Microsoft SQL Server on the 32-bit and 64-bit Microsoft Windows platforms
  • In the July 2013 release of SAS/ACCESS on SAS 9.4M2, support was added for the SAP HANA relational database interface.
  • In SAS 9.4M2, support was added for the Impala interface.
  • In SAS 9.4, support was added for the Vertica interface.

For a detailed list of enhancements, see "What's New in SAS/ACCESS 9.4 for Relational Databases" in SAS/ACCESS for Relational Databases: Reference.

Enhancements for SAS/ACCESS for Nonrelational Databases

  • In the April 2019 release of SAS/ACCESS on SAS 9.4M6, support was added for these features:
    • MongoDB interface
    • Salesforce interface 
  • In the February 2016 release of SAS/ACCESS on SAS 9.4M4, support was added for the Asset Framework and event frames for the PI System nonrelational database. 
  • In SAS 9.4M2, support was added for the Data Archive in the PI System interface.
For a detailed list of enhancements, see “What’s New in SAS/ACCESS for Nonrelational Databases” in SAS/ACCESS for Nonrelational Databases: Reference.

Enhancements for SAS/ACCESS Interface to PC Files

  • In SAS Viya 3.4, support was added for Stata 15 support for >32,787 variables, >2B rows (on import only), and UTF-8 encoding. 
  • In SAS Viya 3.3, support was added for the SAS Data Connector to PC Files. 
  • In SAS 9.4M5, support was added for these features:
    • Ability to import data to CAS tables with PROC IMPORT and the CAS LIBNAME engine. PROC EXPORT can store VARCHARs in SPSS, Stata, JMP, and Excel XLSX files.
    • In the IMPORT procedure, the specification DBMS=XLSX now supports currency values using the NLMNY format.
  • In SAS 9.4M4, support was added for these features: 
    • Ability to add a Microsoft Excel XLSX worksheet to an existing workbook and to update an existing worksheet in a workbook.
    • Ability to create new XLSX output files when using the EXPORT procedure with DBMS=EXCELCS or when using the PCFILES LIBNAME engine.
    • Ability to export Excel XLSX files to UNIX. You can now specify DBMS=XLSX to read and write to Excel workbooks under UNIX and Microsoft Windows without needing to access the PC Files Server.
    • Updates to these statements used with the IMPORT and EXPORT procedures: RANGE=, SHEET=, GETNAMES=, GUESSINGROWS=.  
    • Ability to read multiple Stata missing values and map them to multiple SAS special missing values, .a-.z or as a single dot (.), for up to 27 missing values.
    • SAS/ACCESS 9.4 changes for JMP files apply to SAS 9.4 also when using the Base SAS IMPORT and EXPORT procedures.
  • In SAS 9.4M2, support was added for these features:

For a detailed list of enhancements, see “What’s New in SAS/ACCESS 9.4 Interface to PC Files” in SAS/ACCESS Interface to PC Files: Reference

 

Videos & Tutorials

Ready to read, write and update data regardless of its native database or platform? These resources are a good place to start.


Documentation

Find user's guides and other technical documentation for SAS/ACCESS.


SAS Viya 3.4 & SAS 9.4

Related Documentation

The following documentation also applies to the SAS 9.4 release:



Previous Versions

SAS 9.3

See also SAS In-Database Technology and SAS Data Surveyor.

  • SAS/ACCESS 9.3 for Relational Databases: Reference, Second Edition PDF | HTML
  • SAS/ACCESS 9.3 Interface to PC Files: Reference PDF | HTML
  • SAS/ACCESS 9.3 DATA Step Interface to CA-IDMS: Reference PDF | HTML
  • SAS/ACCESS 9.3 Interface to ADABAS: Reference PDF | HTML
  • SAS/ACCESS 9.3 Interface to CA-Datacom/DB: Reference PDF | HTML
  • SAS/ACCESS 9.3 Interface to IMS: Reference PDF | HTML
  • SAS/ACCESS 9.3 Interface to SYSTEM 2000: Reference PDF | HTML
  • SAS/ACCESS 4.4 Interface to R/3: User's Guide PDF | HTML
  • The documentation for the SAS/ACCESS Interface to Hadoop is in SAS/ACCESS 9.3 for Relational Databases: Reference, Second Edition. The FILENAME statement (for the Hadoop access method) is in SAS 9.3 Statements: Reference, and the HADOOP procedure is in the Base SAS 9.3 Procedures Guide, Second Edition.

 

SAS 9.2

See also SAS In-Database Technology and SAS Data Surveyor.

  • SAS/ACCESS 9.2 for Relational Databases: Reference, Fourth Edition PDF | HTML
  • SAS/ACCESS 9.2 Interface to PC Files: Reference, Second Edition PDF | HTML
  • SAS/ACCESS 9.2 DATA Step Interface to CA-IDMS: Reference PDF | HTML
  • SAS/ACCESS 9.2 Interface to ADABAS: Reference PDF | HTML
  • SAS/ACCESS 9.2 Interface to CA-Datacom/DB: Reference PDF | HTML
  • SAS/ACCESS 9.2 Interface to IMS: Reference PDF | HTML
  • SAS/ACCESS 9.2 Interface to SYSTEM 2000: Reference PDF | HTML
  • SAS/ACCESS 4.3 Interface to R/3: User's Guide PDF | HTML
  • SAS/ACCESS Procedures HTML
     

SAS 9.1.3

See also SAS Data Surveyor.

  • What's New in SAS/ACCESS 9.0, 9.1, 9.1.2, and 9.1.3 Interfaces to Relational Databases HTML
  • What's New in SAS/ACCESS 4.2 Interface to R/3 HTML
  • What's New in SAS/ACCESS 4.1 Interface to R/3 HTML
     

Most Used Documentation

  • SAS/ACCESS 9.1 DATA Step Interface to CA-IDMS: Reference PDF
  • SAS/ACCESS 9.1.3 for Relational Databases: Reference, Fifth Edition PDF
  • SAS/ACCESS 9.1 Interface to ADABAS: Reference PDF
  • SAS/ACCESS 9.1 Interface to Baan: User's Guide PDF
  • SAS/ACCESS 9.1 Interface to CA-Datacom/DB: Reference PDF
  • SAS/ACCESS 9.1 Interface to IMS: Reference PDF
  • SAS/ACCESS 9.1 Interface to PC Files: Reference PDF
  • SAS/ACCESS 9.1 Interface to PeopleSoft: User's Guide PDF
  • SAS/ACCESS 4.2 Interface to R/3: User's Guide PDF
  • SAS/ACCESS 9.1 Interface to SAP BW: User's Guide PDF
  • SAS/ACCESS 9.1 Interface to SYSTEM 2000: Reference PDF

Supplements

  • SAS/ACCESS 9.1.3 Supplement for DB2 under UNIX and PC Hosts: SAS/ACCESS for Relational Databases PDF
  • SAS/ACCESS 9.1.3 Supplement for DB2 under z/OS: SAS/ACCESS for Relational Databases, Second Edition PDF
  • SAS/ACCESS 9.1.3 Supplement for HP Neoview: SAS/ACCESS for Relational Databases PDF
  • SAS/ACCESS 9 Supplement for Informix: SAS/ACCESS for Relational Databases PDF
  • SAS/ACCESS 9 Supplement for Microsoft SQL Server: SAS/ACCESS for Relational Databases PDF
  • SAS/ACCESS 9.1.3 Supplement for MySQL: SAS/ACCESS for Relational Databases PDF
  • SAS/ACCESS 9.1.3 Supplement for Netezza: SAS/ACCESS for Relational Databases PDF
  • SAS/ACCESS 9.1 Supplement for ODBC: SAS/ACCESS for Relational Databases PDF
  • SAS/ACCESS 9.1 Supplement for OLE DB: SAS/ACCESS for Relational Databases PDF
  • SAS/ACCESS 9.1.3 Supplement for Oracle: SAS/ACCESS for Relational Databases PDF
  • SAS/ACCESS 9.1 Supplement for Sybase: SAS/ACCESS for Relational Databases PDF
  • SAS/ACCESS 9.1.3 Supplement for Teradata: SAS/ACCESS for Relational Databases, Second Edition PDF
     

SAS 9.1.2 and 9.1

  • What's New in SAS/ACCESS 9.1 Interface to ADABAS HTML
  • What's New in SAS/ACCESS 9.0 and 9.1 Interface to CA-Datacom/DB HTML
  • What's New in SAS/ACCESS 9.0 and 9.1 Interface to IMS HTML
  • What's New in SAS/ACCESS 9.0 and 9.1 for PC Files HTML
  • What's New in SAS/ ACCESS 9.0, 9.1, 9.1.2, and 9.1.3 Interfaces to Relational Databases HTML
  • SAS/ACCESS 9.1 Interface to Relational Databases: Reference PDF
  • SAS/ACCESS 9.1.2 for Relational Databases: Reference PDF
  • SAS/ACCESS 9.1 Supplement for DB2 under UNIX and PC Hosts: SAS/ACCESS for Relational Databases PDF
  • SAS/ACCESS 9.1 Supplement for DB2 under z/OS: SAS/ACCESS for Relational Databases PDF
  • SAS/ACCESS 9.1 Supplement for ORACLE: SAS/ACCESS for Relational Databases PDF
  • SAS/ACCESS 9 Supplement for SYBASE: SAS/ACCESS for Relational Databases PDF
  • SAS/ACCESS 9.1 Supplement for Teradata: SAS/ACCESS for Relational Databases PDF
     

Software Downloads

The downloads application contains updates for SAS products and solutions.

SAS/ACCESS Communities

Connect with other SAS users by joining a users group or attending an upcoming event.

Back to Top