SAS/ACCESS

Title Level Training Formats
SAS Programming Fast Track
This course provides you with thorough understanding of the Base SAS programming language. You get the opportunity to work with basic access to data, manipulation of data as well as presentation of data from SAS Enterprise Guide, SAS Studio or Display Manager System.
You will learn how to master the most important techniques within data step programming, load data, manage data and organize data efficiently in SAS data sets. This course combines the course content of the two courses SAS Programming 1: Essentials and SAS Programming 2: Data Manipulation Techniques.

2 Fundamental Classroom
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 Classroom Live Web Classroom
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 Classroom Live Web Classroom
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 Classroom Live Web Classroom e-Learning
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 Classroom Live Web Classroom e-Learning
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 Classroom Live Web Classroom