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.  

The most recent releases are SAS 9.4M7 and SAS® Viya® 3.5.

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
Google BigQuery PC Files
HadoopPostgreSQL
ImpalaSalesforce
JDBCSAP HANA
Microsoft SQL ServerSnowflake
MongoDB
Teradata
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

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

MongoDB
PI System
Salesforce

Additional Resources for SAS Interfaces to Hadoop

Recent Enhancements for SAS/ACCESS for Relational Databases

  • In SAS 9.4M7 (August 2020), the following updates or enhancements were made:
    • Support was added for the Spark interface on SAS 9.4.
    • Support was added for the Yellowbrick interface.
    • In-database processing of summary procedures was enabled for Google BigQuery and Snowflake interfaces.
    • Bulk unloading was added for Google BigQuery.
    • Support for bulk loading from Microsoft SQL Server to Azure Synapse Analytics was added for users with a Microsoft Azure Data Lake Storage Gen2 storage account.
  • In the November 2019 release of SAS 9.4M6 and SAS Viya 3.5 release, support was added for these enhancements:
    • Google BigQuery: support for the ARRAY, GEOGRAPHY, NUMERIC, and RECORD data types
    • MySQL: support for the JSON data type
    • ODBC: support for the Linux on Power Architecture platform
    • PostgreSQL: support for the Linux on Power Architecture platform and support for bulk unloading
    • Teradata: support for the NUMBER data type
    • Sample programs are now located at the GitHub repository
  • In the August 2019 release of SAS/ACCESS, support was added for these interfaces:
    • Google BigQuery
    • Snowflake

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.

Recent Enhancements for SAS/ACCESS for Nonrelational Databases

  • In SAS 9.4M7 (August 2020), support was added for the following updates or enhancements for the PI System interface:
    • attribute values up to 32767 bytes
    • username and password authentication using the SAS_PI_WEB_AUTH= environment variable
    • updated syntax to access PI System tags in the Asset Framework
  • In the November 2019 release of SAS/ACCESS on SAS 9.4M6 and SAS Viya 3.5, support for these features was added:
    • MongoDB: data connector
    • Salesforce: data connector and support for the 64-bit Microsoft Windows platform
For a detailed list of enhancements, see “What’s New in SAS/ACCESS for Nonrelational Databases” in SAS/ACCESS for Nonrelational Databases: Reference.

Recent Enhancements for SAS/ACCESS Interface to PC Files

  • In the November 2019 release of SAS/ACCESS for SAS 9.4M6 and SAS Viya 3.5, support was added for the Linux on Power Architecture platform.

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.5 & 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
         Note: Beginning in SAS 9.4M7, this product is no longer available with SAS offerings.
  • SAS/ACCESS 9.3 Interface to ADABAS: Reference PDF | HTML
  • SAS/ACCESS 9.3 Interface to CA-Datacom/DB: Reference PDF | HTML
         Note: Beginning in SAS 9.4M7, this product is no longer available with SAS offerings.
  • 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