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.
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
Before attending this course, you should be comfortable programming in SAS and Structured Query Language (SQL). You can gain this experience 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 Teradata is helpful.
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
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
https://www.exitcertified.com/it-training/sas/sas-data-management/sas-data-integration/interface-teradata-49083-detail.htmlDIACTDIntroduction to SAS/ACCESS(R) Interface to Teradatahttps://assets.exitcertified.com/assets/CourseImages/d77abef6bd/AdobeStock_193300479__FitMaxWzEwMDAsMTAwMF0.jpg650.00USDInStock/Training/SAS/Data Management/Data IntegrationThis course teaches you how to read Teradata tables in Teradata using the SAS 9.4 SAS/ACCESS Interface to Teradata. You learn...650.00SASClassroom2016-11-21T09:31:04+00:00USD