SAS/ACCESS
Title | Level | Training Formats |
---|---|---|
SAS SQL Methods and More
This class teaches you how to improve the performance of SQL queries, and how to troubleshoot and tune other SAS processes that access relational database tables using SAS/ACCESS interfaces. |
3 Intermediate | ![]() ![]() ![]() ![]() ![]() |
Processing Database and PC File Data with SAS/ACCESS Software
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. |
3 Intermediate | ![]() ![]() ![]() ![]() ![]() |
Efficiency Tips for Database Programming in SAS
This class teaches you how to tune your SAS programs for faster execution, especially those that access relational database tables using SAS/ACCESS interfaces or SAS Viya data connectors. |
3 Intermediate | ![]() ![]() ![]() ![]() ![]() |
Introduction to SAS/ACCESS 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 multiple Teradata tables. You also learn efficiency techniques and options for optimizing data access performance. |
3 Intermediate | ![]() ![]() ![]() ![]() ![]() |
SAS Certification Review: SAS 9.4 Base Programming Performance-Based Exam
This course provides a review of the majority of topics in the SAS 9.4 Base Programming Performance-Based Exam. It addresses the four exam content areas: Accessing and Creating Data Structures, Managing Data, Generating Reports and Output, and Handling Errors. |
3 Intermediate | ![]() ![]() ![]() ![]() ![]() |
High-Performance Data Manipulation with SAS DS2
This course focuses on learning DS2, a fourth-generation SAS language for advanced data manipulation. DS2 blends DATA step and SQL syntax with modern programming structures, and enables parallel processing in Base SAS as well as massively parallel processing environments such as Hadoop and SAS Viya Cloud Analytic Services (CAS). A brief introduction to SAS Viya is included. |
4 Expert | ![]() ![]() ![]() ![]() ![]() |