DOCUMENTATION
  • Software
    • Software
    • SAS Viya
    • Industries
    • Solutions
    • Products
  • Learn
    • Learn
    • Training
    • Certification
    • Academics
    • Books
    • Video Tutorials
  • Support
    • Support
    • Communities
    • Documentation
    • Developers
    • Support & Services
    • User Groups
  • About Us
    • About Us
    • Why SAS?
    • Company
    • Careers
    • Newsroom
    • Events
    • Contact Us
  • Explore
    • Explore
    • Try & Buy
    • Why SAS?
    • Customer Stories
    • Partners
    • Consulting
  • Software
  • SAS Viya
  • Industries
  • Solutions
  • Products
  • Learn
  • Training
  • Certification
  • Academics
  • Books
  • Video Tutorials
  • Support
  • Communities
  • Documentation
  • Developers
  • Support & Services
  • User Groups
  • About Us
  • Why SAS?
  • Company
  • Careers
  • Newsroom
  • Events
  • Contact Us
  • Explore
  • Try & Buy
  • Why SAS?
  • Customer Stories
  • Partners
  • Consulting
  • Contact Us
Sign In

Create Profile

My SAS

Get access to My SAS, trials, communities and more.

SAS Sites

sas.com
Support
Blogs
Communities
Developer
Curiosity
Videos

Documentation

Learn
Brand
PartnerNet
Merchandise
SAS® Help Center
SAS® Viya® Programming Documentation
2022.1.1
|PDF 
Feedback
 
This documentation is for a version of the software that is not covered by Standard Support. Select a different version from the version selector in the banner, or access the latest documentation.
  • Welcome to SAS Programming Documentation
  • What's New
  • Learning SAS Viya
  • Syntax Quick Links
  • Advanced Analytics
  • Data Access
    • CAS User’s Guide
    • SAS/ACCESS for Relational Databases
    • SAS/ACCESS for Nonrelational Databases: Reference
    • SAS/ACCESS for PC Files for Viya
    • SAS/ACCESS for R/3
    • SAS/ACCESS Documentation
    • ORC and Parquet Engines
    • V9 Engine
    • SPD Engine: HDFS
    • SPD Engine
    • XMLV2 and XML Engines
    • SAS LIBNAME Engine for SAS Federation Server
    • Moving and Accessing SAS Files
    • SAS/CONNECT for SAS Viya User’s Guide
  • Cloud Analytic Services
  • SAS Language Reference
  • Migrating to UTF-8
  • Example Data Sets
  • SAS Code Debugging
  • Output and Graphics
  • In-Database Technologies
  • Security and Administration
  • SAS Servers
  • Using the batch Plug-In for the SAS Viya CLI
  • SAS Data Quality
  • SAS Job Execution Web Application
  • Accessibility in SAS Viya
  • SAS Visual Analytics
  • SAS Viya: Administration
  • SAS Viya Operations
  • SAS Studio
  • Other Resources
SAS/ACCESS for Relational Databases
 

SAS/ACCESS® for Relational Databases: Reference

Concepts
Overview of SAS/ACCESS Interface to Relational Databases
Using SAS/ACCESS with the SAS Viya Platform
SAS Names and Support for DBMS Names
Data Integrity and Security
Performance Considerations
Optimizing Your SQL Usage
Threaded Reads
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 DB2
SAS/ACCESS Interface to Google BigQuery
SAS/ACCESS Interface to Greenplum
SAS/ACCESS Interface to Hadoop
SAS/ACCESS Interface to Impala
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 Oracle
SAS/ACCESS Interface to PostgreSQL
SAS/ACCESS Interface to SAP ASE
SAS/ACCESS Interface to SAP HANA
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
Last updated: August 1, 2024
Privacy Statement Terms of Use 
Copyright © SAS Institute Inc. All Rights Reserved