Complete & Practical SAS, Statistics & Data Analysis Course

A complete guide and use cases study for job seekers and beginners -- start career in SAS, Statistics and Data science

Created byShenggang Li

Last updated 12/2018

English

What you'll learn

Be equipped with a powerful tool for the most sexy data analytics career path!
Read and write various types of raw data with different formats and options
Create and modify various professional and statistical reports
Be aware of statistical analysis and concepts such as non parametric test, interaction, correlation..
Master the most complete SAS graphics tool such GTL and statistical plots
Learn comprehensive SAS Macro programming knowledge -- variables and user defined functions
Perform many real world case studies -- retail banks, credit bureau, marketing firms and clinical trials
Apply powerful data manipulation -- SQL, subsetting, slicing, filtering, transformation, ranking, sorting..
Understand data management and data piping
Use SAS ODS -- help deliver many useful objects such as charts, tables between different systems
Hundreds of SAS sample codes to explain arrays, functions and business cases

Course content

21 sections • 171 lectures • 16h 36m total length

What are you going to learn from this course14:47
This tutorial describes what are you going to take away from this complete training for job seekers and beginners

Introduce SAS environment0:47
We will learn key windows under SAS environment
SAS library2:11
Learn concepts about SAS library
Try SAS codes2:51
Learn SAS environment, library and data creating by running SAS program
Home work and data installation9:22
This is a guide to let you know how to set up homework. A zipped file (resource) is provided in this session
SAS Cloud Version0:14
Introduction to SAS Studio Installation on University Edition17:30
Show how to install and run SAS Studio on University Edition

Create data sets from external files2:11
Learn how to create SAS data sets from external files such as .TXT and .CSV.
SAS program - create data sets3:03
In this lecture, we will learn how a SAS program is running and generate physical data sets.
Valid names and comments1:38
In this lecture we learn, what are correct naming rules in SAS and how to set comments in SAS programming
SAS program -- Valid names and comments2:06
Data type and format2:51
In this lecture we learn, what are data types and formats which can be used in SAS data and programming
SAS program -- data type and format4:07
SAS program - date and format2:39
Mechanism of SAS data set1:23
In this lecture, we will learn how a SAS program is running and generate physical data sets.
Summarize SAS operations2:24
In this lecture we learn, what are major SAS operations which can be realized using the SAS programming knowledge and skills that we will learn in the later sections.

List input (1)2:13
In this lecture we learn, what is list input in SAS, How should we create a SAS data set by reading data using list input method.
List input (2)1:42
SAS program -- list input4:58
Read data with fixed layout3:07
In this lecture we learn, how to read raw data if the data format and potions are fixed.
Read data with modified list input2:59
In this lecture we learn,about inputting data using input modifiers under some special cases such as date type in SAS . .
Input data with other features13:17
Write data using data step1:28
In this lecture we learn, how to write SAS data into external files such as TXT and CSV
SAS program --write data2:28
Import and export data4:08
In this lecture we learn, how to import and export data using Wizard tools and SAS coding methods.

Duplicate data sets0:46
In this lecture we learn, how to duplicate data sets in SAS.
SAS program -- duplicate data sets1:20
Modify variables0:32
We will learn how to add and modify columns or variables of SAS data sets using data step
SAS program -- modify variables1:21
Variables selection.4:25
We'll look at using various data step statements on column selection.
Rename variables1:00
We'll see how how to change column names in SAS data sets
SAS program -- rename variables1:30
Assign labels to variables1:36
We will learn what is label and how to assign labels to variables in SAS data sets
SAS program -- assign labels to variables2:08
Subsetting data sets6:05
Introduce some methods for subsetting data sets
SAS program -- Subsetting data sets1:18

Data step character functions5:48
In this lecture, we will learn how to use data step character functions
SAS program --data step character functions3:49
Data step numeric functions2:12
SAS program -- numeric functions5:47
Data step special functions2:30
Data step special functions9:53
In this lecture we learn, How to apply date and special functions and how to improve performance in data steps
User defined format4:40
In this lecture we learn, what is user defined format and PROC format in SAS, How to create your own data formats to tailor your different needs .
SAS program -- User defined format9:45

Case study 001(read employee data)2:07
In this lecture we walk though the data reading using employee data set in SAS
SAS program -- read employee data3:00
Case study 002(read chronic disease data)1:16
In this lecture we walk though the data reading using pharmaceutical data set in SAS. Codes can be downloaded
SAS program -- Case study 002(read chronic disease data)3:04
Case study 003 ( read business account data)0:26
In this lecture we walk though the data reading using business account data set in SAS. Codes can be downloaded
SAS program -- Case study 003 ( read business account data)1:49
Case study 004 (process stock data)1:35
In this lecture we walk though the data reading using stock market data set in SAS. Codes can be downloaded
SAS program -- Case study 004 (process stock data)3:49

Automatic Variables(_N_ and _ERROR_)11:03
In this lecture we learn, what is automatic SAS variable. Specifically, we introduce the usages of _N_ and _ERROR_ in data step programming
Output statement8:24
In this lecture we show, how to use output statement in data step.
Return statement10:59
In this lecture we learn, how to apply a return statement and break loop in SAS.
pinpoint the first and last record2:35
SAS program -- Pinpoint the first and last record1:34
In this lecture we learn, how to use first and last statements to pinpoint the first and last record in SAS data sets
Retain statement6:41
In this lecture we learn, how to handle the previous record using retain statement
SAS program -- Retain statement2:49
Data step array (1)8:53
In this lecture we learn, what is SAS array and how to apply array in data step
Data step array (2)7:38
In this lecture we learn, what is SAS array and how to apply array in data step

Requirements

Basic computer operational skills.
Basic math skills.
Data intuition

Description

You should take this course!

• If you need a complete and comprehensive package that covers SAS programming, intuitive statistics interpretation, data analysis, and predictive modeling, and

• If you would like to learn by doing various practical use cases fitting in the positions in different business portfolios, and

• Whether you are a job seeker or beginner intending to start a data science career

Then this around 18 hours course is right for you!

This complete SAS course includes more than 150 lectures and contains 11 real world case studies/projects in different applied areas such as banking and marketing. After this intensive training, you will be equipped with a powerful tool for the most sexy data analytics career path!

Who this course is for:

Beginners or job seekers interested in learning SAS Programming, statistical and data analysis in industry fields.
People who wish to enter data science/analytics field.

Complete & Practical SAS, Statistics & Data Analysis Course

What you'll learn

Explore related topics

Course content

Introduction1 lecture • 15min

SAS environment and basic concepts6 lectures • 33min

Get started SAS programming9 lectures • 22min

Input and output raw data9 lectures • 36min

Manipulate data by data step programming11 lectures • 22min

Control flow in SAS4 lectures • 20min

SAS data step functions8 lectures • 44min

Use cases study (1)8 lectures • 17min

Other SAS features in data step programming9 lectures • 1hr 1min

Use cases study (2)2 lectures • 22min

Requirements

Description

Who this course is for: