title
SAS/ACCESS® Software
shelf-menu
title
SAS/ACCESS®
description
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.
support-dropdown
background-image
icon
heading

Videos & Tutorials

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

Enabling in-database processing with SAS/ACCESS to Teradata

Enabling in-database processing with SAS/ACCESS to Teradata

icon
heading

Training Courses

subheading
Learn SAS technology quickly and efficiently by taking a course from the analytics experts.
text-align
center

SAS/ACCESS

Processing Database and PC File Data with SAS/ACCESS Software

This course teaches you how to process data using SAS/ACCESS software. Databases and PC files covered in this course are Microsoft Excel, Microsoft Access, Oracle, DB2, Teradata, and Microsoft SQL Server via ODBC. Also included is a brief discussion about Hadoop, JMP, dBase, STATA, SPSS, and R.

Introduction to SAS/ACCESS Interface to Teradata

This course teaches you how to read Teradata tables in Teradata using the SAS 9.4 SAS/ACCESS Interface to Teradata. You learn how to connect to Teradata and to query a single Teradata table and multiple Teradata tables. You also learn efficiency techniques and options for optimizing data access performance..

Introduction to SAS and Hadoop

This course teaches you how to use SAS programming methods to read, write, and manipulate Hadoop data. Base SAS methods that are covered include reading and writing raw data with the DATA step and managing the Hadoop file system and executing Map-Reduce and Pig code from SAS via the HADOOP procedure.

Learning path for Data Management

icon
heading

Documentation

subheading
Find user's guides and other technical documentation for SAS/ACCESS.
text-align
center

See also SAS In-Database Technologies and SAS Data Surveyor

SAS Viya Platform

SAS 9.4

Related Documentation

heading

Previous Versions

text-align
center
SAS Viya 3.X

The documents listed below contain information about the appropriate SAS Viya 3.x release.

Viya 3.5

Viya 3.4

Viya 3.3

Viya 3.1

SAS 9.3

See also SAS In-Database Technologies 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.
heading

SAS Technical Papers

subheading
Read technical papers to learn how to complete a task or achieve a goal.
text-align
center

2020 SAS Global Forum Papers

2019 SAS Global Forum Papers

2018 SAS Global Forum Papers

SAS/ACCESS
Hadoop
Data Modeling Considerations in Hadoop and Hive
heading

Hot Fixes

subheading
Find quick solutions to problems or conduct routine system maintenance. SAS hot fixes have been tested and are fully supported.
text-align
center
SAS 9.4
SAS 9.3
SAS 9.2
heading

Software Downloads

subheading
The downloads application contains updates for SAS products and solutions.
text-align
center

SAS/ACCESS

heading

SAS/ACCESS Communities

text-align
center

Find your community

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

/en/fragments/software/get-help