SAS/ACCESS

Title Level Training Formats
SAS Certification Review: Base Programming for SAS 9
This course provides a review of the majority of topics in the SAS Base Programming Exam for SAS 9. It addresses the five exam content areas: Accessing Data, Creating Data Structures, Managing Data, Generating Reports, and Handling Errors.

3 Intermediate Live Web Classroom e-Learning
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 Live Web Classroom
Introduction to SAS and Hadoop
This course teaches you how to use SAS programming methods to read, write, and manipulate Hadoop data. Base SAS methods that are covered include reading and writing raw data with the DATA step and managing the Hadoop file system and executing Map-Reduce and Pig code from SAS via the HADOOP procedure. In addition, the SAS/ACCESS Interface to Hadoop methods that allow LIBNAME access and SQL pass-through techniques to read and write Hadoop HIVE or Cloudera Impala tables structures is part of this course. Although not covered in any detail, a brief overview of additional SAS and Hadoop technologies, including DS2, high-performance analytics, SAS LASR Server, and in- memory Statistics, as well as the computing infrastructure and data access methods that support these, is also part of this course. This course is included in the Expert Exchange on Hadoop: Using SAS/ACCESS service offering to configure SAS/ACCESS Interface to Hadoop or SAS/ACCESS Interface to Impala to work with your Hadoop environment.

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 Live Web Classroom e-Learning
Hadoop Data Management with Hive, Pig, and SAS
In this course, you use processing methods to prepare structured and unstructured big data for analysis. You learn to organize this data into structured tabular form using Apache Hive and Apache Pig. You also learn SAS software technology and techniques that integrate with Hive and Pig and how to leverage these open source capabilities by programming with Base SAS and SAS/ACCESS Interface to Hadoop, and with SAS Data Integration Studio.

The Extended Learning page for this course includes the option to purchase Virtual Lab time to practice.

The e-learning format of this course also includes the option to purchase Virtual Lab time to practice.

3 Intermediate Classroom Live Web Classroom e-Learning