Did you know that 92 of the top 100 companies on the 2018 Fortune 1000 use SAS?
One major reason SAS dominates with Fortune 100 companies is that they provide numerous Big Data management applications that work together to solve complicated business problems. They have data Access, Quality, Integration, Governance and Architecture solutions that work together seamlessly.
What ties all the different solutions together is the SAS programming language. The SAS programming language is the focus of this course. No matter what software solution you use, the programming is the same. Learning SAS programming enables a company to go beyond the Graphical Interfaces of the individual SAS solutions to allow for flexible solutions for the particular situation faced.
Our course is self-paced and includes over 11 hours of video lectures. Assignments and Quizzes will test your understanding. Our SAS training is very much a hands-on experience.
You will learn primarily via our high-quality video lectures, but when needed, you'll have access to SAS Online Tutor support, that is 1-on-1 support, whenever you request it.
Check out the Curriculum and video lectures available for free preview.
Skills You Will Obtain:
- SAS Data Step (primary technique to create and manipulate data-sets)
- SAS Proc Step
- SAS SQL (a fit for those of you looking for sas and sql training, as SAS SQL is the SAS implementation of SQL)
- Macro Facility (more advanced topic)
- SAS Indexes (more advanced topic)
- An Introduction to SAS Predictive Modeling (more specialized topic)
Our goal is to offer quality and affordable training to companies that want to outsource their training. We can easily accommodate a major purchase where we will provide all employees with their own individual access to course content.
We also have many students that are individuals who want to up-skill on their own because their current company uses SAS and it helps them gain a promotion.
Course Curriculum
First Section
Available in
days
days
after you enroll
Section 2: Importing - SAS Import Data
Available in
days
days
after you enroll
Section 3: Working with Data
Available in
days
days
after you enroll
-
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)
-
Filtering Observations (so only some data show up)
(2:04)
-
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
Section 4: Input Types and Informats + User-defined formats
Available in
days
days
after you enroll
Section 5: Arrays
Available in
days
days
after you enroll
Section 6: SAS Functions
Available in
days
days
after you enroll
-
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
Available in
days
days
after you enroll
Section 8: Advanced Techniques - Flexibility and Efficiency
Available in
days
days
after you enroll
Section 9: Visual representation of data
Available in
days
days
after you enroll
Section 10: Statistical Analysis
Available in
days
days
after you enroll
Section 11: Statistical Analysis - Part 2 (Linear and Multiple Regression)
Available in
days
days
after you enroll
Section 12: Case Studies
Available in
days
days
after you enroll
Section 13: SQL Fundamentals
Available in
days
days
after you enroll
Section 14: SAS SQL and Joining
Available in
days
days
after you enroll
Section 15: Working with Tables using SAS SQL
Available in
days
days
after you enroll
Section 16: Practical Application of SAS SQL
Available in
days
days
after you enroll
Section 17: Fundamentals of utilizing SAS Indexes
Available in
days
days
after you enroll
-
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
Available in
days
days
after you enroll
-
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
Available in
days
days
after you enroll
Section 20: SAS Predictive Modeling, Understanding the Problem and the Data
Available in
days
days
after you enroll
Section 21: SAS Predictive Modeling, Preparing the Input Variables
Available in
days
days
after you enroll
-
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
Available in
days
days
after you enroll
Instructor
Frequently Asked Questions
When does the course start and finish?
The course has no start-dates or end-dates. You start when you want, take breaks when you want, and can complete the course when you are able to.
How long do I have access to the course?
When you buy this course, you have unlimited access to this course for as long as you like - across any and all devices you own.
What if I am unhappy with the course?
We offer a 30 day money back guarantee. If you are unsatisfied with your purchase, contact us in the first 30 days and we will give you a full refund.