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