Introduction
- Introduction
- WPS and SAS
- Download Software
- Install Software
- Layout Arrangement
- Interface Introduction
- Course Material Links & Instructions (Video tutorial in next lecture)
- Course Materials
Import and Export Data
- Import From Text File Into SAS
- Import Excel Into SAS
- Import CSV into SAS
- Enter Data Within Program
- Export SAS Data
Modifying SAS Data
- Print Data
- Create Columns
- Remove Columns
- If-Else Condition
- Sort SAS Data
- Combine SAS Data
SAS Programming Techniques
- SAS Library - Manage Data Efficiently
- Using Comments In SAS
Fundamental Analysis In SAS
- Report Data Contents
- Report Data Statistics (Average, Maximum, etc.)
- Correlation Analysis
Advanced Analysis In SAS
- What is Regression?
- Simple Regression
- Understanding Results
- Regression Options
- Multiple Regression
- Interpreting Results
- Making Predictions
- Regression Review
Creating Charts and Plots in SAS
- Introduction to Visualization
- Scatter Plot
- Series Plot
- Bar Plot and Pie Plot
- Overlaying Plots
Working with SAS SQL
- Introduction to SAS SQL
- SQL Select Columns
- SQL Count Statement
- SQL Distinct Statement
- SQL Group By Statement
- SQL Create Table
- SQL Merge Statement
Making Detailed SAS Reports
- Learn Proc Print
- Produce Detailed Report
- Enhanced Detailed Report (Part 1)
- Enhanced Detailed Report (Part 2)
- Ultimate Detailed Report
Case Studies
- Case Study 00 : Revenue Prediction
- Case Study 00: Solution - Part 1
- Case Study 00 : Solution - Part 2
- 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 Date & Time Functions
- Introduction to SAS Date & Time
- Human Readable Dates
- Create Date & Time Variables
- Convert String to Dates
- Calculations on Dates
- Move Dates by Months and Years
- Extract Day, Month, and Year from Dates
- SAS Date & Time in Practice
SAS Text Functions
- Introduction to Text Variables in SAS - NEW LECTURE
- LENGTH Function - Length of String
- "||" Operand - Concatenate String
- CAT, CATS, and CATX Functions
- LEFT, RIGHT Functions - Align Texts
- UPCASE, LOWCASE Functions - Change Letter Cases
- TRIM Function - Remove blank spaces
- COMPRESS Function - Remove Characters (Part 1)
- COMPRESS Function - Remove Characters (Part 2)
- INDEX Function - Find Substrings
- SUBSTR Function - Extract Substrings
- SCAN Function - Split Strings (Part 1)
- SCAN Function - Split Strings (Part 2)
SAS Formatting Functions - NEW SECTION
- What is SAS Format?
