Inserting Rows with a Query and Set Statement

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)

Inserting Rows with a Query and Set Statement

Lesson content locked

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

Enroll in Course to Unlock