Summer-Ready Savings: Find the Training Course You Need at a Price You'll Love

closeClose

Processing Database and PC File Data with SAS/ACCESS(R) Software

Course Details
Code: DIACS
Tuition (USD): $1,300.00 • Classroom (2 days)

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.

Skills Gained

  • 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 Can Benefit

  • SAS programmers that need to access data in Database Management Systems and PC files from within SAS

Prerequisites

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

Course Details

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
Contact Us 1-800-803-3948
Contact Us Live Chat
FAQ Get immediate answers to our most frequently asked qestions. View FAQs arrow_forward