Complete & Practical SAS, Statistics & Data Analysis Course

Duration

3 days

What you'll learn

• 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

Course content

SAS environment and basic concepts

• Introduce SAS environment
• SAS library
• Try SAS codes
• SAS Cloud Version
• Introduction to SAS Studio Installation on University Edition

Get started SAS programming

• Create data sets from external files
• SAS program - create data sets
• Valid names and comments
• SAS program -- Valid names and comments
• Data type and format
• SAS program -- data type and format
• SAS program - date and format
• Mechanism of SAS data set
• Summarize SAS operations

Input and output raw data

• List input (1)
• List input (2)
• SAS program -- list input
• Read data with fixed layout
• Read data with modified list input
• Input data with other features
• Write data using data step
• SAS program --write data
• Import and export data

Manipulate data by data step programming

• Duplicate data sets
• SAS program -- duplicate data sets
• Modify variables
• SAS program -- modify variables
• Variables selection.
• Rename variables
• SAS program -- rename variables
• Assign labels to variables
• SAS program -- assign labels to variables
• Subsetting data sets
• SAS program -- Subsetting data sets

Control flow in SAS4 lectures

• Structured programming
• SAS program -- Structured programming
• Structured programming (II)
• SAS program -- Structured programming (II)

SAS data step functions

• Data step character functions
• SAS program --data step character functions
• Data step numeric functions
• SAS program -- numeric functions
• Data step special functions
• User defined format
• SAS program -- User defined format

Use cases study (1)

• Case study 001(read employee data)
• SAS program -- read employee data
• Case study 002(read chronic disease data)
• SAS program -- Case study 002(read chronic disease data)
• Case study 003 ( read business account data)
• SAS program -- Case study 003 ( read business account data)
• Case study 004 (process stock data)
• SAS program -- Case study 004 (process stock data)

Other SAS features in data step programming

• Automatic Variables(_N_ and _ERROR_)
• Output statement
• Return statement
• pinpoint the first and last record
• SAS program -- Pinpoint the first and last record
• Retain statement
• SAS program -- Retain statement
• Data step array

Use cases study (2)

• Case study 005(create new KPI features)
• Case study 006(students grades)

Browse, sort and combine data

• Browse and print data set
• SAS program -- Browse and print data set
• Sort data
• SAS program -- sort data
• Merge multiple data sets
• Stack data sets
• Examples of merging and splitting data sets

Data processing and analysis

• Transpose data sets
• Examples of transposing data
• Understand statistics and distribution..
• Summarize continuous data
• Examples of PROC MEANS
• Summarize categorical variables
• Examples of PROC FREQ
• Understand uni-variate study
• Examples of uni-variate analysis
• Ranking data and bucket analysis
• Application of PROC RANK to use cases
• SAS ODS
• Use cases of SAS ODS

Data management

• Look up data structure -- PROC CONTENTS
• Examples of PROC CONTENTS
• Data management using PROC Datasets
• Learn PROC FSLIST pipe

SAS SQL5 lectures

• SAS SQL (1)
• SAS SQL (2)
• SAS SQL (3)
• SAS SQL (4)
• SAS SQL (5)

Use cases study (3)

• Case study 007 (market analysis 1)
• SAS program -- Case study 007 (market analysis 1)
• Case study 008 (market analysis 2)
• SAS program -- Case study 008 (market analysis 2)

Produce statistical report

• Create Tabular report (1)
• SAS program -- Create Tabular report (1)
• SAS program -- create Tabular report (1) Cont.
• Create Tabular report (2)
• SAS program -- create Tabular report (2)
• Create Tabular report (3)

Create professional report

• PROC REPORT (1)
• SAS program -- PROC REPORT (2)
• PROC REPORT (3)
• PROC REPORT (4)

Data and statistical analysis

• Create data sample
• SAS program -- create data sample
• Data standdardization
• SAS program -- data standzrdization
• Handle missing values in SAS
• Correlation analysis
• SAS program -- Correlation analysis
• Statistical test (1)
• Statistical test (2)
• Statistical test (3)

SAS Macro

• Introduce SAS Macro
• SAS macro variable (1)
• Examples of SAS macro variable (1)
• SAS macro variables (2)
• Examples of SAS macro variables (2)
• SAS macro programs (1)
• SAS macro programs (2)
• SAS macro programs (3)
• SAS program -- SAS macro programs (3)
• SAS macro functions (1)
• SAS program -- SAS macro functions (1)
• SAS macro functions (2)
• SAS program -- SAS macro functions (2)
• SAS macro functions (3)
• SAS macro functions (4)
• Call execute routine
• Associate SQL to SAS macro

Use case study (4)

• Apply SAS Macro to correlation study
• Credit risk analysis in SAS (1)
• SAS program -- Credit risk analysis in SAS (1)
• Case study 011 (reporting, chart and ODS)
• SAS program -- Case study 011 (reporting, chart and ODS)
• SAS Graphics (1)
• SAS Graphics (2)

Programme scope, delivery arrangements and suitability are confirmed during enquiry.