Target group
SAS programmers who need to access data in Teradata from within SAS
Course structure
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
