Introduction
  • Introduction
  • Course Content
  • WPS and SAS
  • Choose Software
  • Download WPS
  • Install WPS
  • Interface Arrangement
  • Using WPS Workbench
  • Course Materials
  • Download Course Materials
Import Data
  • Import Text File into SAS
  • Import Excel into SAS
  • Import CSV into SAS
  • Import Quiz
  • Enter Data within Program
  • Export SAS Data
Working with Data
  • Print Data
  • Print Quiz
  • Create Columns
  • Quiz
  • Remove Columns
  • Columns operation Quiz
  • IF-Else Condition
  • Quiz
  • Sort SAS Data
  • Sort Quiz
  • Combine SAS Data
  • Combine Quiz
  • SAS Comments
  • SAS Library
  • Homework 001
  • Homework Solution 001
Analysing Data - Basics
  • Report Data Contents
  • Report Data Statistics (Average, Maximum, etc.)
  • Correlation Analysis
Analysing Data - Advanced
  • What is Regression?
  • Simple Regression
  • Understanding Results
  • Regression Options
  • Multiple Regression
  • Interpreting Results
  • Making Predictions
  • Regression Review
Visualization
  • Why is Data Visualization Useful?
  • Scatter Plot
  • Series Plot
  • Bar Plot and Pie Plot
  • Overlaying Plots
Working with SQL
  • What is SQL?
  • SQL Select Columns
  • SQL Count Statement
  • SQL Distinct Statement
  • SQL Group Statement
  • SQL Create Table
  • SQL Left Join
Case Studies
  • Case Study 00 : Revenue Prediction
  • Case Study 00: Solution - Part 1
  • Case Study 00 : Solution - Part 1
  • Case Study 00 : Notes
  • Case Study 01 : Baseball Player
  • Case Study 01 : Solution
  • Case Study 01 : Notes
  • Case Study 02 : Car Sales Analysis
  • Case Study 02 : Solution
  • Case Study 02 : Notes
  • Case Study 03 : Stock Market
  • Case Study 03 : Solution
  • Case Study 03 : Notes
  • Case Study 04 : Real estate
  • Case Study 04 : Solution
  • Case Study 04 : Notes
SAS Macro
  • What is SAS Macro?
  • SAS Macro Variable
  • SAS Macro Function
Dive Into SAS Dates
  • What is SAS Dates?
  • Human Readable Dates
  • Create Dates
  • Convert String to Dates
  • Calculations on Dates
  • Move Dates by Month or Year
  • Extract Day, Month, or Year
  • SAS Dates in Practice
Dive Into SAS Character Variables
  • What is Character/String Variable
  • Length of String
  • Concatenate Strings
  • Concatenation Functions
  • Text Alignment Functions
  • Convert Text Cases
  • Remove Blanks From String