Base SAS

標題 等級 培訓格式
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 Live Web Classroom
Data Visualization Using SAS ODS Graphics
本課程介紹如何利用 SAS ODS 圖形語法建立高品質的資料視覺化分析。

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
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 Live Web Classroom e-Learning
Exporting SAS Data Sets and Creating ODS Files for Microsoft Excel

3 Intermediate Classroom
FDP-Shaping a Data Science Curriculum: Data Management, Machine Learning and Artificial Intelligence
This FDP supports developing a data science program that covers a variety of topics and enables students to acquire the skills that industry is looking for their employees to have. The FDP helps universities develop a pool of talent with the range of analytical and technology skills to work in a data-rich business environment.

1 Beginner Live Web Classroom
FDP - Shaping an Analytics Curriculum (A SAS & Open Source Approach)
This outline is provisional and subject to change.The Faculty Development Program (FDP) teaches you fundamental concepts and relevant techniques in analytics and machine learning using a powerful mix of SAS and open-source programming languages. The course also enables you to explore academic and collaborative opportunities with SAS in the area of advance analytics for designing better curriculum and effective pedagogy.

0 No level Live Web Classroom
Feature Engineering and Data Preparation for Analytics
本課程介紹如何利用SAS 程式語法進行特徵工程,萃取出有意義的輸入變數,以增進預測模型的表現。同時課程中也會對建模過程常見的資料選取陷阱進行說明,並提供避免踏入陷阱的適合策略。

4 Expert 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 a variety of Hadoop distributed file system (HDFS) storage formats for processing efficiency using Apache Hive and Apache Pig. You also learn SAS software technologies 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.

3 Intermediate Live Web Classroom e-Learning
High-Performance Data Manipulation with SAS DS2
本課程介紹如何利用第四代SAS 程式語言進行進階資料處理。DS2 語法混合 DATA step跟 SQL 語法,讓使用者在 SAS Base 上進行平行處理,或在MPP 架構下的 Hadoop 與Viya CAS 中做平行運算。

4 Expert 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
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 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 table structures are discussed. Although not covered in detail, a brief overview of additional SAS and Hadoop technologies, including executing DS2 in Hadoop with the SAS Code Accelerator for Hadoop and using Hadoop data sources for the distributed in-memory analytics platform of SAS Viya, is included. 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 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.

1 Beginner e-Learning
Programming for SAS Viya New
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.

3 Intermediate Classroom Live Web Classroom e-Learning
SAS Advanced Programming: Fast Track
This course is for users who want to learn advanced SAS programming. This course combines the SAS Programming 3: Advanced Techniques and Efficiencies, SAS SQL 1: Essentials, and SAS Macro Language 1: Essentials courses. This course is not recommended for those who have not programmed before.

4 Expert Live Web Classroom
SAS Certification Review: Base Programming for SAS 9
本課程專為欲準備基礎程式認證考試的人員規劃,將在此課程中複習關於基礎程式認證的主要觀念。本課程將涵蓋5大考試內容的觀念:讀取資料、建立資料架構、整理資料、產生報表及處理錯誤狀況。本課程可幫助您準備認證考試:SAS Base Programming Exam for SAS 9的基礎觀念。

3 Intermediate Classroom Live Web Classroom 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.

3 Intermediate e-Learning
SAS Macro Language 1: Essentials
本課程重點在了解SAS 巨集語法,以及如何設計、編寫巨集程式並除錯,重點在於了解含有巨集的程式是如何運作的。

4 Expert Classroom Live Web Classroom e-Learning
SAS Macro Language 2: Advanced Techniques

4 Expert Classroom e-Learning
SAS Programming 1: Essentials Free e-learning
本課程專為欲學習如何撰寫SAS程式的使用者規劃,是學習SAS程式撰寫的入門課程,為後續眾多SAS課程之基礎。但若您沒有撰寫SAS程式的需求,而是較喜歡使用點選的操作方式,則可建議您參加SAS Enterprise Guide 1: Querying and Reporting(EG1)課程。

2 Fundamental Classroom Live Web Classroom e-Learning
SAS Programming 2: Data Manipulation Techniques
本課程介紹SAS DATA step與PROC step 進行資料處理的方法,包含資料讀取、轉置以及資料彙總。本課程為SAS Programming 1: Essential的延續課程,不建議初學者直接參與本課程。

3 Intermediate Classroom Live Web Classroom e-Learning
SAS Programming 3: Advanced Techniques and Efficiencies

4 Expert Classroom Live Web Classroom e-Learning
SAS Programming Certification Fast Track
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. This course is also for those who need to learn data manipulation techniques using the SAS DATA step and SAS procedures to access, transform, and summarize data.It is a prerequisite to many other SAS courses.

0 No level Live Web Classroom
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 e-Learning
SAS Report Writing
本課程介紹如何利用 SAS 程式語法製作明細報表或彙總報表,同時也會介紹如何利用 SAS Output Delivery System 來優化報表的呈現。

3 Intermediate Classroom Live Web Classroom e-Learning
SAS SQL 1: Essentials
本課程介紹如何在SAS 利用結構性查詢語法(Structured Query Language)處理SAS資料。

3 Intermediate Classroom Live Web Classroom e-Learning
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 Live Web Classroom
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.

3 Intermediate e-Learning