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.

Learn how to

• process relational database data and PC file data using the LIBNAME statement, SQL pass-through facility
• import PC file data using the IMPORT procedure, as well as export data using the EXPORT procedure
• use In-Database Processing methods to submit Base SAS procedures to relational database for processing
• improve performance with the SAS/ACCESS LIBNAME statement.

Who should attend SAS programmers that need to access data in Database Management Systems and PC files from within SAS Formats available Duration
: 4 half day sessions

Before attending this course, you should be comfortable programming in SAS and Structured Query Language (SQL). You can gain the SQL knowledge from the course. You can gain knowledge of SAS from the course. A working knowledge of your database is helpful.

This course addresses SAS/ACCESS software.

Introduction

• course logistics
• overview of SAS/ACCESS software
• syntax for the SQL pass-through facility
• syntax for the SAS/ACCESS LIBNAME statement

Using the SAS/ACCESS Interface to PC Files

• using the IMPORT procedure
• using the EXPORT procedure
• using the SQL pass-through facility
• using the SAS/ACCESS LIBNAME engine

Using the SAS/ACCESS Interface to Oracle

• connecting to Oracle and investigating Oracle metadata
• creating SQL pass-through queries
• using the SAS/ACCESS LIBNAME engine

Using the SAS/ACCESS Interface to DB2

• creating SQL pass-through queries
• using the SAS/ACCESS LIBNAME engine

Using the SAS/ACCESS Interface to Teradata

• creating SQL pass-through queries
• using the SAS/ACCESS LIBNAME engine

Using the SAS/ACCESS Interface to ODBC

• creating an ODBC data source
• accessing an ODBC data source

Additional Data Sources

• accessing additional data sources

Base SAS In-Database Processing

• overview of SAS In-Database technology
• using Base SAS In-Database procedures

Performance Considerations

• improving performance with the LIBNAME statement

DIACS.