Autoplay
Autocomplete
Previous Lesson
Complete and Continue
SAS Programming Complete: Learn SAS and Become a Data Ninja
Introduction
All the data-sets (so you can follow along)
How to Find, Install, and Use SAS Studio/SAS OnDemand For Academics
How to Find, Install, and Use WPS (9:40)
Important Note About Watching Course
Maps Activity (This one you can just watch!) (4:47)
Importing - Using SAS to Import Data
Import txt (2:00)
Import csv (6:05)
Import xlsx (3:59)
Fundamentals - Understanding SAS Better
Data Step vs Proc Step (4:02)
SAS Syntax (7:07)
Comparing R, Python and SAS When Manually Creating Data (8:05)
Working with Data
Data Set Options (4:39)
Delimiters (2:55)
Reading Data Instream (5:10)
How to read Dates (6:02)
Creating Variables and Calculations (4:01)
More on Creating New Variables (4:16)
Automatic Variables (3:57)
Filtering Observations (2:04)
If-then Conditional Logic (5:40)
Do Iterative Loop And Variations (6:51)
More on DO Group Processing (without index/counter variable) (3:55)
More on Where Expression (3:56)
If vs. Where
Sorting Observations (3:21)
Merging Two Data-sets (3:33)
Using SET statement to Merge (3:41)
Data Reduction and Cleaning (6:43)
Length Statement (8:08)
Counting Variable (4:26)
Input Types and Informats + User-defined formats
List Input (4:18)
Column Input (4:21)
Formatted input and Informats (5:55)
User Defined Formats (7:48)
SAS Arrays
Arrays 1 (Recoding Variables) (7:00)
Arrays 2 (Constructing new Variables) (4:48)
SAS Functions
Understanding SAS Functions (9:16)
RAND Function (5:29)
Length Functions (6:56)
Trim Function (2:55)
Compress Function (3:53)
Input and Put Functions (7:42)
Catx Function (3:15)
Scan Function (3:28)
Coalesce Function (3:24)
Verify Function (5:04)
Substr Function (4:08)
Advanced Techniques - Flexibility and Efficiency
Flexible Programming 1 - Combining multiple raw data files vertically (10:42)
Assignments for Data Step
Integration Assignments Intro
Integration Assignment 1
Integration Assignment 1 Solution
Integration Assignment 2
Integration Assignment 2 Solution
Visual Representation of Data
Scatter Plot (4:45)
Bar Graph (2:12)
Statistical Analysis 1
Information For This Section
T-Test Independent Overview (7:03)
Performing T-Test Using SAS (3:24)
Chi-Square Independent Overview (6:08)
Perform Chi-Square Using SAS (3:18)
Statistical Analysis 2
Performing a Linear Regression (4:10)
Performing Multiple Regression (3:38)
Case Study for Data Step
Case Study Part 1 (9:46)
Case Study Part 2 (11:33)
SAS SQL Fundamentals
SQL Syntax (8:38)
Where Clause (6:08)
Select Statement (5:17)
Case Logic (3:17)
Summary Functions (3:20)
SAS SQL Assignment 1
SAS SQL Assignment 1 Solution
SAS SQL and Joining
Inner Join (8:52)
Joining Three Tables (2:24)
How to Perform a Left/Right Join (4:05)
How to Perform a Full Join (6:18)
SAS SQL Assignment 2
SAS SQL Assignment 2 Solution
Working with Tables using SAS SQL
Creating a Table (4:26)
Altering Columns (5:27)
Inserting Rows (7:02)
SAS SQL Assignment 3
SAS SQL Assignment 3 Solution
Practical Applications of SAS SQL
Comparing Tables SQL (2:28)
Finding Duplicate Rows (3:05)
Only Display Unique Records/Rows
Customize the way you Sort (3:40)
Updating Table Under Certain Conditions (4:58)
SAS SQL Assignment 4
SAS SQL Assignment 4 Solution
Fundamentals of utilizing SAS Indexes
Intro to Indices (1:56)
Should you use an Index? (2:01)
Types of Indices (2:01)
Index Options (1:45)
Testing with Large Data-sets (4:04)
Selecting Variable(s) for your Index (4:18)
PROC Data-sets and WHERE Expression (5:59)
BY Statement (Sorting variables, while exploiting your Index) (3:59)
Using PROC SQL to create Indices
Creating an Index During Data Step Execution
Deleting Indices
Handling Common Tasks with an Indexed Data-set (3:27)
Updating the Master Data-Set with new variables or observations (7:06)
Macro Facility Fundamentals
Macro Facility Intro Article
Types of Macro Variables (4:46)
Don't Lose Track of your Macro Variables (2:31)
Macro Variable Assignment Rules (3:14)
Masking Special Characters (4:09)
Macro Functions (%Index and %Upcase) (3:58)
Macro Functions 2 (%Scan) (4:31)
Macro Programs Intro (5:59)
Macro 1 - Average Sales Example (6:39)
Macro 2 - Sales Reports for different days (5:59)
Debugging (3:32)
Storing Macros (4:23)
Macro Case Study
Brainstorming for Case Study (4:57)
Macro Case Study 1 (7:59)
Macro Case Study 2 (7:14)
Introduction to Predictive Modeling With SAS
Understanding The Business Applications (2:04)
Analytics Challenges (3:03)
Predictive Modeling Major Steps (4:28)
Intuitive Understanding of Logistic Regression (7:56)
Problem Statement And Hypothesis Generation (3:42)
Data Audit (6:02)
Univariate Analysis (11:22)
Bivariate Analysis (13:48)
House-keeping *important* (7:09)
Sources, Patterns and Mechanisms of Missing Data (6:09)
Update Your Code
Evaluating Missing Data Patterns with SAS (4:51)
3 Phase Multiple Imputation Process using SAS (11:42)
Some additional code for PROC MI (if you are getting an error)
Considering the Output from PROC MI (3:21)
Mean, Mode and Median Imputation (Article, SAS Code)
Oversampling and Adjusting for Oversampling (9:42)
Categorical Inputs (8:47)
Variable Clustering (8:00)
Multicollinearity (5:17)
Subset Selection (6:32)
Parameter Estimates (2:13)
Discrimination vs. Calibration (Article)
ROC Curve (7:51)
Scoring Validation Data Set Using Code (3:31)
Decile Calibration Plot (5:55)
Kolmorgov-Smirnov (Article)
Feature Engineering (2:52)
Appendix - Extra Content
Top 5 SAS Base Certification Questions Answered (19:36)
Some additional code for PROC MI (if you are getting an error)
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock