COMPRESS Function (remove characters from string, and all types …40.

SAS Programming : From Zero to Hero

First Section

Which Software Should you Use?
SAS Studio (How to Find, Register for, Install, and Upload Data-sets )
How to Find, Install, Register for, Use, and Upload Data-sets with WPS (9:40)
All the Data-Sets (so you can follow along)

Section 2: Importing - SAS Import Data

You Must Upload Data-Sets Before Beginning to Import
Import.txt (2:00)
Import .csv (6:05)
Import .XLSX (8:58)
Importing SPSS file with SAS language (3:33)
Quiz 1: Quiz for Importing

SAS Syntax, Data Step vs. Proc Step, SAS compared to R/Python

Data Step vs. Proc Step (3:51)
SAS Syntax (7:07)
Manually Creating Data with R, Python, and SAS (8:05)

Section 3: Working with Data

Data Set Options (4:39)
What if your data is separated by a dot or something else? (delimiters) (2:55)
Reading data instream in data step (typing data right into coding area) (5:09)
Reading DATES in data (6:02)
Creating variables/Calculations (4:01)
More on Creating New Variables (4:16)
Automatic Variables (3:57)
Filtering Observations (so only some data show up) (2:04)
Intuition Decision and Loop Structures (6:08)
If-then Conditional Logic (5:40)
DO Iterative Loop and Variations (DO WHILE, DO Until) (6:51)
More on DO Group Processing (without index/counter variable) (3:55)
More on the WHERE Expression/Statement (3:56)
IF vs. WHERE
Sorting Observations (PROC SORT and BY statements) (3:21)
Merging Two Data Sets (3:33)
Using SET statement to Merge (3:41)
Data Reduction and Cleaning your Data (6:43)
LENGTH statement (8:08)
Creating a Counting (Enumeration) Variable (4:26)
Quiz 2: Data Section Quiz
Integration Assignment 0.5
Solutions for Integration Assignment 0.5

Section 4: Input Types and Informats + User-defined formats

List Input (4:18)
Column Input (4:20)
Formatted Input And Informats (5:55)
User Defined Formats (7:54)
Quiz 3: Informats/Formats and SAS Input Style Quiz

Section 5: Arrays

Arrays 1 (Recoding Variables) (7:05)
Arrays 2 (Constructing new variables) (4:53)

Section 6: SAS Functions

SAS Functions Intuition (9:16)
RAND Function (producing a sample with distribution of your choi…37. RAND Function (producing a sample with distribution of your choice) (5:29)
LENGTH, LENGTHN, LENGTHC functions (are you working with a larg… (6:56)
TRIM function (want to get rid of trailing blanks?) (2:54)
COMPRESS Function (remove characters from string, and all types …40. COMPRESS Function (remove characters from string, and all types of blanks) (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)
Quiz 4: Functions Quiz

Section 7: Assignments

Integration Assignments
Assignment 1: Integration of Skills 1
Assignment 2: Integration of Skills 2
Solutions for Integration Assignment 1 and Assignment 2

Section 8: Advanced Techniques - Flexibility and Efficiency

Flexible Programming 1 - Combining multiple raw data files ver…48. Flexible Programming 1 - Combining multiple raw data files vertically (10:42)

Section 9: Visual representation of data

Scatter Plot (4:45)
Bar Graph (2:12)

Section 10: Statistical Analysis

Doing an Independent samples t-test analysis (3:24)
Doing a Chi-square (independent groups) analysis (3:18)

Section 11: Statistical Analysis - Part 2 (Linear and Multiple Regression)

Performing the Linear Regression (4:10)
Performing Multiple Regression (3:38)

Section 12: Case Studies

Important note before you start!
Case Study (Health Care Case Study) PART 1 (9:46)
Case Study (Health Care Case Study) PART 2 (11:33)
Code for Case Study
Congrats on Finishing Part 1: Data Step (2:00)

Section 13: SQL Fundamentals

SQL Snytax (8:37)
WHERE Clause (6:13)
SELECT statement and Columns (5:22)
CASE Logic (3:22)
Summary Functions (3:26)
SAS SQL Assignment 1
SAS SQL Assignment 1 Solution

Section 14: SAS SQL and Joining

How to Perform an Inner Join (8:56)
How to Join Three Tables (2:29)
How to Perform a Left/Right Join (4:11)
How to Perform a Full Join (6:24)
SAS SQL Assignment 2
SAS SQL Assignment 2 Solution

Section 15: Working with Tables using SAS SQL

How to Create a Table using SAS SQL (4:30)
Altering Columns (add, modify, delete + adding values to column) (5:33)
Inserting Rows with a Query and Set Statement (7:08)
SAS SQL Assignment 3
SAS SQL Assignment 3 Solution

Section 16: Practical Application of SAS SQL

How to Compare Tables with SAS SQL (2:33)
Finding Duplicate Observations (3:10)
Only Display Unique Records/Rows
Customize the way you Sort (3:46)
How to Update a Table Under Certain Conditions with SAS SQL (5:04)
SAS SQL Assignment 4
SAS SQL Assignment 4 Solution

Section 17: Fundamentals of utilizing SAS Indexes

Intro to Indexes/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)
Assignment 3: Creating, Updating and Using Index Assignment

Section 18: 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:08)
Macro Functions (%Index and %Upcase) (3:58)
Macro Functions 2 (%Scan) (4:31)
Creating a Macro variable (helps you modify data easier) (3:50)
Macro Programs Intro (5:59)
Creating a Macro Example 1 (greater flexibility, +useful for repetitive coding) (8:08)
Creating a Macro Example 1 (greater flexibility, +useful for repetiti…111. Creating a Macro Example 1 (greater flexibility, +useful for repetitive coding) (8:13)
Creating a Macro Example 2 (5:59)
Creating a Macro Example 3 (unique sales reports for different days) (5:59)
Creating a Macro Example 4 (calculating average sales for multiple years) (6:39)
Debugging Options (3:32)
Storing Macros (External) (4:23)
Assignment 4: Macro Assignment 1
Brainstorming for Logistic Macro Case Study (4:57)
Logistic Macro, Case Study, Part 1 (7:58)
Logistic Macro, Case Study, Part 2 (7:14)
Assignment 5: Logistic Macro Case Study Assignment

Section 19: SAS Predictive Modeling using Logistic Regression, Introdu…Section 19: SAS Predictive Mo

Business Applications of Predictive Modeling (2:04)
Analytics Challenges (3:03)
The Major Steps in Predictive Modeling (4:28)
Intuitive understanding of Logistic Regression (7:56)
Data sets used for Predictive Modeling Sections

Section 20: SAS Predictive Modeling, Understanding the Problem and the Data

Problem Statement/Hypothesis Generation (3:42)
Data Audit (6:02)
Univariate Analysis (11:22)
Bivariate Analysis (13:48)
Important Housekeeping (7:09)
Update your Code

Section 21: SAS Predictive Modeling, Preparing the Input Variables

Sources, Patterns and Mechanisms of Missing Data (6:09)
Evaluating Missing Data Patterns with SAS (4:51)
3 Phase Multiple Imputation Process using SAS (11:42)
Some additional code for PROC MI
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)

Section 22: SAS Predictive Modeling, Evaluation Metrics

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)

COMPRESS Function (remove characters from string, and all types …40. COMPRESS Function (remove characters from string, and all types of blanks)

Lesson content locked

If you're already enrolled, you'll need to login.

Enroll in Course to Unlock