sas-training-courses

Introduction to SAS/ACCESS(R) 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...

Read More
$800 USD GSA  $630.68
Course Code DIACTD
Duration 1 day
Available Formats Classroom
6119 Reviews star_rate star_rate star_rate star_rate star_half
Course Image

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.

Skills Gained

  • read Teradata tables using the LIBNAME statement and the SQL pass-through facility
  • use options and efficiency techniques for optimizing data access performance
  • join data using the SQL procedure and the DATA step
  • publish and use SAS formats in Teradata.

Who Can Benefit

  • SAS programmers who need to access data in Teradata from within SAS

Prerequisites

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

Course Details

Introduction

  • course logistics
  • overview of SAS/ACCESS software
  • overview of Teradata
  • connecting to Teradata

Using the SQL Pass-Through Facility

  • connecting to Teradata and investigating Teradata metadata

Using the SAS/ACCESS LBNAME Engine

  • using the LIBNAME statement for Teradata
  • using data set options
  • creating views
  • combining tables

Performance Considerations

  • improving performance with the LIBNAME statement

Base SAS In-Database Technology

  • overview of SAS In-database technology
  • using Base SAS procedures in Teradata
  • using SAS formats and user-defined formats in Teradata

Learning More

Appendix (Self-Study)

  • Introducing Teradata Parallel Transporter Application Programming Interface
  • loading data with FastLoad and MultiLoad
Contact Us 1-800-803-3948
Contact Us
FAQ Get immediate answers to our most frequently asked qestions. View FAQs arrow_forward