Training Console
AU: +61-2 9052 1988    NZ: +64 9 281 1876


Base SAS

Title Level Training Formats
SAS Programming for R Users Free e-learning
This course is for experienced R users who want to apply their existing skills and extend them to the SAS environment. Emphasis is placed on programming and not statistical theory or interpretation. Students in this course should have knowledge of plotting, manipulating data, iterative processing, creating functions, applying functions, linear models, generalized linear models, mixed models, stepwise model selection, matrix algebra, and statistical simulations.

3 Intermediate Classroom Live Web Classroom e-Learning
SAS Report Writing 1: Essentials
This course teaches you how to create detail and summary tabular reports using Base SAS procedures. You also learn how to enhance your reports using the Output Delivery System (ODS).

3 Intermediate Classroom Live Web Classroom e-Learning
SAS Macro Language 2: Advanced Techniques
This course covers macro quoting functions, macro storage, and macro techniques for advanced data access, table lookup operations, advanced parameter validation, and macro windows.

4 Expert Classroom Live Web Classroom e-Learning
Introduction to Statistical Concepts Free e-learning
This course covers basic statistical concepts that are critical for understanding and using statistical methods. This course explains what statistics is and why it is important to understand the characteristics of your data.

The information in this course is a prerequisite for many other statistical courses that SAS Education offers. The course is appropriate for Base SAS and SAS Enterprise Guide users. Data, practices, and a case study are included.

0 No level e-Learning
Social Network Analytics Business Knowledge Series
This course discusses how to leverage social networks for analytical purposes. Obviously, when we say "social networks," many people think of Facebook, Twitter, Google+, LinkedIn, and so on. These are all examples of networks that connect people using either friendship or professional relationships. In this course, we zoom out and provide a much more general definition of a social network. In fact, we define a social network as a network of nodes that are connected using edges. Both nodes and edges can be defined in various ways, depending on the setting. This course starts by describing the basic concepts of social networks and their applications in marketing, risk, fraud, and HR. It then defines various social metrics and illustrates how they can be used for community mining. The course also discusses how social networks can be used for predictive analytics. The course provides a sound mix of both theoretical and technical insights, as well as practical implementation details, and is illustrated by several real-life cases. The instructor extensively reports on both his research and consulting experience in the field. References to background material such as selected papers, tutorials, and guidelines are also provided.

0 No level e-Learning
Big Data Challenges and Analysis-Driven Data
This course provides an overview of the challenges with big data and analysis-driven data.

1 Beginner Classroom
SAS Programming 1: Essentials Free e-learning
This course is for users who want to learn how to write SAS programs to access, explore, prepare, and analyze data. It is the entry point to learning SAS programming for data science, machine learning, and artificial intelligence. It is a prerequisite to many other SAS courses. If you do not plan to write SAS programs and you prefer a point-and-click interface, you should attend the SAS Enterprise Guide 1: Querying and Reporting course.

2 Fundamental Classroom Live Web Classroom e-Learning
Propensity Score Matching, Adjustment, and Randomized Experiments Business Knowledge Series
This course focuses on testing whether the results of a program can be attributed to a given cause. For example, was the increase in customer sales due to mailing of sales flyers? Was the health improvement due to the new medication? What conclusion can be drawn? The following cases are examined: randomized controlled experiments and observational studies that require adjustment to reduce bias by using propensity score analysis through either propensity score matching or propensity score adjustment.

3 Intermediate Classroom
Developing Custom Tasks for SAS Enterprise Guide Business Knowledge Series
SAS Enterprise Guide is a hugely popular application that is used by SAS programmers, SAS power users, and business analysts around the world. It does a lot, but does it do everything that you need it to do? Organizations often have a need to extend or customize their SAS Enterprise Guide environment to fit their particular industry or business processes.

3 Intermediate Classroom
SAS Functions by Example Business Knowledge Series
Ever spent valuable time writing complex code only to later find a function that would have done the job for you? Discover the plethora of practical SAS functions that you haven't seen in other SAS programming courses, and start resolving your everyday programming problems more quickly and efficiently.

3 Intermediate 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
Data Cleaning Techniques Business Knowledge Series
This course, which was completely rewritten to be compatible with the third edition of the book Cody's Data Cleaning Techniques Using SAS, will help greatly speed up the process of detecting and correcting errors in both character and numeric data. In addition, there are sections on standardizing data and using Perl regular expressions to ensure that character values conform to a specific pattern (such as ZIP codes, phone numbers, and email addresses).

Although the course concentrates on methods of identifying data errors, it also teaches some programming techniques that might be new to you. For example, by using some of the latest SAS functions, you can convert a phone number in just about any form into a standard form, in only two SAS statements!

The course teaches several methods of detecting errors in numeric data including range checking as well as several methods of automatic outlier detection. There are chapters devoted to data that involves multiple observations per subject, SAS dates, and projects that include multiple data sets. The class closes with a demonstration of an innovative process that leverages integrity constraints and audit trails to detect and programmatically clean dirty data before it even gets into your analysis data set.

All students taking this class are presented with either a printed version or PDF version of the new Data Cleaning book and are given access to dozens of macros that will greatly speed up the laborious process of cleaning your data.

3 Intermediate Classroom
ODS Graphics: Essentials
This course teaches you how to produce high-quality presentation graphs using ODS Graphics, which is part of Base SAS beginning with SAS 9.3.

3 Intermediate Classroom Live Web Classroom
Exporting SAS Data Sets and Creating ODS Files for Microsoft Excel
This course presents techniques for exporting SAS data sets or reports from SAS to Excel.

3 Intermediate Classroom Live Web Classroom
Building and Solving Optimization Models with SAS/OR
This course focuses on formulating and solving mathematical optimization models using the OPTMODEL procedure, from inputting data to interpreting output and generating reports. The course covers linear, integer, mixed integer, and nonlinear programming problems, with an emphasis on model formulation and construction.

3 Intermediate Classroom Live Web Classroom
Establishing Causal Inferences: Propensity Score Matching, Heckman's Two-Stage Model, Interrupted Time Series, and Regression Discontinuity Models Business Knowledge Series
This course introduces some methods commonly used in program evaluation and real-world effectiveness studies, including two-stage modeling, interrupted time-series, regression discontinuity, and propensity score matching. These methods help address questions such as: Which medicine is more effective in the real world? Did an advertising program have an impact on sales? More generally, are the changes in outcomes causally related to the program being run?

3 Intermediate e-Learning
SAS Federation Server: Accessing and Virtualizing Enterprise Data
SAS Federation Server makes it easier for business users to access secure data for reporting and analysis. It provides a virtual layer or view, giving users the appropriate level of control without physically moving data. This frees up IT staff to focus on other tasks by giving them a simple method of sharing data using a centralized, governed security layer

The self-study e-learning includes:

  • Annotatable course notes in PDF format.
  • Virtual Lab time to practice.

3 Intermediate Classroom e-Learning
Exploring SAS Studio for SAS Programmers
This course provides an introduction to SAS Studio for experienced SAS programmers. SAS Studio is an interface that enables users to write and submit SAS programs and use snippets and tasks to generate SAS code.

The self-study e-learning includes:

  • Annotatable course notes in PDF format.
  • Virtual Lab time to practice.

3 Intermediate 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 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
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 Programming 2: Data Manipulation Techniques
This course is for those who need to learn data manipulation techniques using the SAS DATA step and procedures to access, transform, and summarize data. The course builds on the concepts that are presented in the SAS Programming 1: Essentials course and is not recommended for beginning SAS software users.

3 Intermediate Classroom Live Web Classroom e-Learning
Programming for SAS Viya
This course is for users who need to modify existing Base SAS programs that will execute in SAS Viya. This course leverages the power of SAS Cloud Analytic Services (CAS) to access, manage, and manipulate in-memory tables. This course is not intended for beginning SAS software users.

The e-learning includes Virtual Lab time to practice.

3 Intermediate Classroom Live Web Classroom e-Learning
SAS SQL 1: Essentials
This course teaches you how to process SAS data using Structured Query Language (SQL).

3 Intermediate Classroom Live Web Classroom e-Learning
Producing Maps with SAS/GRAPH
This course teaches you to use SAS/GRAPH software to produce various types of maps to display geographically based data. In addition, you learn how to add annotations to maps, and create and modify map data sets.

4 Expert Classroom
Feature Engineering and Data Preparation for Analytics
This course introduces programming techniques to craft and feature engineer meaningful inputs to improve predictive modeling performance. In addition, this course provides strategies to preemptively spot and avoid common pitfalls that compromise the integrity of the data being used to build a predictive model. This course relies heavily on SAS programming techniques to accomplish the desired objectives.

4 Expert Classroom
DS2 Programming: Essentials
This course focuses on DS2, which is a fourth-generation SAS proprietary language for advanced data manipulation. DS2 enables parallel processing and storage of large data with re-usable methods and packages. This course is designed for programmers with large data who want to use modern programming techniques and structures.

4 Expert Classroom Live Web Classroom
SAS Macro Language 1: Essentials
This course focuses on using the SAS macro facility to design, write, and debug macro programs, with an emphasis on understanding how programs that contain macro code are processed.

4 Expert Classroom Live Web Classroom e-Learning
SAS Programming 3: Advanced Techniques New
This course is for SAS programmers who want to learn advanced techniques within the DATA step and procedures. The course builds on the concepts that are presented in the SAS Programming 2: Data Manipulation Techniques course.

4 Expert Classroom Live Web Classroom e-Learning