SAS/ACCESS 9.4 for Relational Databases: Reference, Ninth Edition :: SAS/ACCESS 9.4 for Relational Databases: Reference, Ninth Edition

Concepts

Overview of SAS/ACCESS Interface to Relational Databases

Using SAS/ACCESS with SAS Viya

SAS Names and Support for DBMS Names

Data Integrity and Security

Performance Considerations

Optimizing Your SQL Usage

National Language Support

How SAS/ACCESS Works

In-Database Processing with SAS/ACCESS

General Reference

SAS/ACCESS Features by Host

The LIBNAME Statement

Data Set Options

Macro Variables and System Options

SQL Pass-Through Facility

DBMS-Specific Reference

SAS/ACCESS Interface to Amazon Redshift

SAS/ACCESS Interface to Aster

SAS/ACCESS Interface to DB2 under UNIX and PC Hosts

SAS/ACCESS Interface to DB2 under z/OS

SAS/ACCESS Interface to Google BigQuery

SAS/ACCESS Interface to Greenplum

SAS/ACCESS Interface to Hadoop

SAS/ACCESS Interface to HAWQ

SAS/ACCESS Interface to Impala

SAS/ACCESS Interface to Informix

SAS/ACCESS Interface to JDBC

SAS/ACCESS Interface to Microsoft SQL Server

SAS/ACCESS Interface to MySQL

SAS/ACCESS Interface to Netezza

SAS/ACCESS Interface to ODBC

SAS/ACCESS Interface to OLE DB

SAS/ACCESS Interface to Oracle

SAS/ACCESS Interface to PostgreSQL

SAS/ACCESS Interface to SAP ASE

SAS/ACCESS Interface to SAP HANA

SAS/ACCESS Interface to SAP IQ

SAS/ACCESS Interface to Snowflake

SAS/ACCESS Interface to Spark

SAS/ACCESS Interface to Teradata

SAS/ACCESS Interface to Vertica

SAS/ACCESS Interface to Yellowbrick

Appendixes

ACCESS Procedure

CV2VIEW Procedure

DBLOAD Procedure

Last updated: February 3, 2026