Home

All courses

SAS Programming Complete: Learn SAS and Become a Data Ninja

Business

Business Analytics & Intelligence

SAS

SAS Programming Complete: Learn SAS and Become a Data Ninja

Use the SAS Data Step, SQL, and Macros

4.7

(2830)

20561 enrolled on this course

Last updated 11/2021

Ermin Dedic

₹ 3099.0

₹ 4599.0

Buy Now

30-Day Money-Back Guarantee

Lessons

Quizzes

Duration

13 Hours

Skill level

Beginner

Language

English

Certificate

Yes

Full lifetime access

Yes

Description

SAS Programming Complete
is perfect for beginners but delves into more intermediate topics. For example, you will learn how to develop a predictive model.
If you are using SAS Enterprise Guide and want to learn how to code/program instead of using the point-and-click interface, this course is ideal! The course also introduces SAS model building.
The first part of the course utilizes the Data step, the 2nd part looks at SAS SQL, and the third part looks at Macro Programming/Programs
Additionally, I have added a section on SAS Predictive Modeling using Logistic Regression. Here, we will build a predictive model (also known as Predictive Analytics)
While the course is for beginners, it is comprehensive and covers some advanced topics. This also allows students who have previous experience to benefit from the course. Furthermore, since you get the LIFE course, you can use it as a resource anytime.
SAS programming continues to be the language of choice for most enterprises/corporations. In 2018, 92% of Fortune 100 companies utilized SAS. It is the go-to for many industries, including banking/finance, insurance, healthcare, pharmaceuticals, and automotive.
My SAS training course was also developed to help you become a certified SAS Specialist: Base Programming Certified. I have received numerous private messages from students who have passed the SAS Base exam, work-related exams, or interviews because of this course. I love hearing this!
The lessons in this course are meant to be taken in order, as each lesson builds upon knowledge, and may mention some crucial ideas/concepts. If you skip videos, it may appear that some aspects are not being explained. For example, if you skip the import.txt lecture because you only care about importing .csv files, you may miss explanations about specific lines of code.
Nevertheless, you will learn a lot!
So, whether you want to start a career/gain employment, or move up at your current company, this course can help you with school projects and prepare you for a career after you complete your education.
Learning SAS programming means you can accomplish the same goal with any software supporting the SAS language.
Finally, you have nothing to lose. No risk! You get a 30-day money-back guarantee.
Enroll now! Your future looks brighter with SAS training.
DISCLAIMER
We are not in any way affiliated or associated with the SAS Institute. We do not provide, nor do we endorse, a download of the SAS University edition for your learning purposes, nor do we personally use SAS software or SAS logos. We make no mention of them (their website, content, screenshots of their assets), nor do we distribute it, nor do we suggest it's ours. We use a commercial license from WPS. The system I use, WPS, is in no way associated with the SAS System.
Who this course is for:
Users of SAS Enterprise Guide, as being able to code inside of EG is the next natural step and skill to obtain.
Individuals that are considering a career, or want to gain employment, with the biggest corporations/enterprises out there!
Individuals looking to become a SAS Certified Specialist: Base Programming
Those new to SAS syntax and or students looking for a refresher. No prior programming knowledge is required.

What you'll learn

Discover the data step, the primary way to program in SAS.

Discover the proc step, a more specialized kind of processing that is utilized for more particular tasks.

Apply SAS SQL, the SAS interpretation of SQL.

Learn techniques to decrease the amount of code you have to type, and learn to deal with big data.

Grow your skill by learning how to create a SAS model for advanced analytics.

Obtain skills needed to pass SAS Certified Specialist: Base Programming exam.

Requirements

You will need a copy of Adobe XD 2019 or above. A free trial can be downloaded from Adobe.
No previous design experience is needed.
No previous Adobe XD skills are needed.

Course Content

27 sections • 95 lectures

Expand All Sections

1-Introduction

1.1-SAS Enterprise Guide, SAS Studio, WPS ***very important***

1.2-SAS Studio/SAS OnDemand for Academics - Register, Upload, Run Code

1.3-WPS (no longer suggested)

1.4-All the Data-sets are attached to this Lecture!

1.5-Common Problems With Install/Upload/Videos (Watch for Best Course Experience!)

2-Importing

2.1-Import .txt

2.2-Import .csv

2.3-Import .XLSX

2.4-Quiz for Importing

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

3.1-Data Step vs. Proc Step

3.2-SAS Syntax

3.3-Manually Creating Data with R, Python, and SAS

4-Working with Data

4.1-Data Set Options

4.2-What if your data is separated by a dot or something else? (delimiters)

4.3-Reading data instream in data step (typing data right into coding area)

4.4-Reading DATES in data

4.5-Creating Variables/Calculations

4.6-More on Creating New Variables

4.7-Automatic Variables

4.8-Filtering Observations (so only some data show up)

4.9-Intuition For If-Then/Else and Do, Do-While, Do-Until

4.10-If-then Conditional Logic

4.11-DO Iterative Loop and Variations (DO WHILE, DO Until)

4.12-More on DO Group Processing (without index/counter variable)

4.13-More on the WHERE Expression/Statement

4.14-IF vs. WHERE

4.15-Sorting Observations (PROC SORT and BY statements)

4.16-Merging Two Data Sets

4.17-Using SET statement to Merge

4.18-Data Reduction and Cleaning your Data

4.19-LENGTH statement

4.20-Creating a Counting (Enumeration) Variable

4.21-Data Section Quiz

4.22-Assignment 0.5: Integration Assignment 0.5

5-Back to Importing

5.1-Importing SPSS file with SAS language

6-Input Types and Informats + User-defined formats

6.1-List Input

6.2-Column Input

6.3-Formatted Input And Informats

6.4-User Defined Formats

6.5-Informats/Formats and SAS Input Style Quiz

7-Arrays

7.1-Arrays 1 (Recoding Variables)

7.2-Arrays 2 (Constructing new variables)

8-SAS Functions

8.1-Understanding SAS Functions

8.2-RAND Function (producing a sample with distribution of your choice)

8.3-LENGTH, LENGTHN, LENGTHC functions (are you working with a large data set?)

8.4-TRIM function (want to get rid of trailing blanks?)

8.5-COMPRESS Function (remove characters from string, and all types of blanks)

8.6-Input and Put Functions

8.7-CATX function

8.8-SCAN function

8.9-Help Me Understand Your Needs

8.10-Coalesce function

8.11-Verify function

8.12-Substr function

8.13-Functions Quiz

9-Assignments

9.1-Integration Assignments

9.2-Integration of Skills 1

9.3-Integration of Skills 2

9.4-Ratings/Reviews

10-Advanced Techniques - Flexibility and Efficiency

10.1-Flexible Programming 1 - Combining multiple raw data files vertically

11-Visual representation of data

11.1-Scatter Plot

11.2-Bar Graph

12-Statistical Analysis

12.1-Some information for this section

12.2-T-test independent samples overview (example)

12.3-Doing an Independent samples t-test analysis

12.4-Chi-square independence overview (example)

12.5-Doing a Chi-square (independent groups) analysis

13-Statistical Analysis - Part 2 (Linear and Multiple Regression)

13.1-Refresh Your Memory - Regression Edition

13.2-Performing the Linear Regression

13.3-Performing Multiple Regression

14-Case Studies

14.1-Important note before you start!

14.2-Case Study (Health Care Case Study) PART 1

14.3-Case Study (Health Care Case Study) PART 2

14.4-Code for Case Study

14.5-Congrats on Finishing Part 1: Data Step

15-SQL Fundamentals

15.1-SQL Snytax

15.2-WHERE Clause

15.3-SELECT statement and Columns

15.4-CASE Logic

15.5-Summary Functions

15.6-SAS SQL Assignment 1

15.7-SAS SQL Assignment 1 Solution

16-SAS SQL and Joining

16.1-How to Perform an Inner Join

16.2-How to Join Three Tables

16.3-How to Perform a Left/Right Join

16.4-How to Perform a Full Join

16.5-SAS SQL Assignment 2

16.6-SAS SQL Assignment 2 Solution

17-Working with Tables using SAS SQL

17.1-How to Create a Table using SAS SQL

17.2-Altering Columns (add, modify, delete + adding values to column)

17.3-Inserting Rows with a Query and Set Statement

17.4-SAS SQL Assignment 3

17.5-SAS SQL Assignment 3 Solution

18-Practical Application of SAS SQL

18.1-How to Compare Tables with SAS SQL

18.2-Finding Duplicate Observations

18.3-Only Display Unique Records/Rows

18.4-Customize the way you Sort

18.5-How to Update a Table Under Certain Conditions with SAS SQL

18.6-SAS SQL Assignment 4

18.7-SAS SQL Assignment 4 Solution

19-Fundamentals of utilizing SAS Indexes

19.1-Intro to Indexes/Indices

19.2-Should you use an Index?

19.3-Types of Indices

19.4-Index Options

19.5-Testing with Large Data-sets

19.6-Selecting Variable(s) for your Index

19.7-PROC Data-sets and WHERE Expression

19.8-BY Statement (Sorting variables, while exploiting your Index)

19.9-Using PROC SQL to create Indices

19.10-Creating an Index During Data Step Execution

19.11-Deleting Indices

19.12-Handling Common Tasks with an Indexed Data-set

19.13-Updating the Master Data-Set with new variables or observations

19.14-Creating, Updating and Using Index Assignment

20-Macro Facility Fundamentals

20.1-Macro Facility Intro Article

20.2-Types of Macro Variables

20.3-Don't Lose Track of your Macro Variables

20.4-Macro Variable Assignment Rules

20.5-Masking Special Characters

20.6-Macro Functions (%Index and %Upcase)

20.7-Macro Functions 2 (%Scan)

20.8-Creating a Macro variable (helps you modify data easier)

20.9-Macro Programs Intro

20.10-Creating a Macro Example 1 (greater flexibility, +useful for repetitive coding)

20.11-Creating a Macro Example 2 (unique sales reports for different days)

20.12-Creating a Macro Example 3 (calculating average sales for multiple years)

20.13-Debugging Options

20.14-Storing Macros (External)

20.15-Macro Assignment 1

20.16-Brainstorming for Logistic Macro Case Study

20.17-Logistic Macro, Case Study, Part 1

20.18-Logistic Macro, Case Study, Part 2

20.19-Logistic Macro Case Study Assignment

21-SAS Predictive Modeling using Logistic Regression, Introduction

21.1-Data sets used for Predictive Modeling Sections

21.2-Business Applications of Predictive Modeling

21.3-Analytics Challenges

21.4-The Major Steps in Predictive Modeling

21.5-Intuitive understanding of Logistic Regression

22-SAS Model - Predictive Modeling, Understanding the Problem and the Data

22.1-Problem Statement/Hypothesis Generation

22.2-Data Audit

22.3-Univariate Analysis

22.4-Bivariate Analysis

22.5-Important Housekeeping

22.6-Update your Code

23-SAS Predictive Modeling, Preparing the Input Variables

23.1-Sources, Patterns and Mechanisms of Missing Data

23.2-Evaluating Missing Data Patterns with SAS

23.3-3 Phase Multiple Imputation Process using SAS

23.4-Some additional code for PROC MI

23.5-Considering the Output from PROC MI

23.6-Mean, Mode and Median Imputation (Article, SAS Code)

23.7-Oversampling and Adjusting for Oversampling

23.8-Categorical Inputs

23.9-Variable Clustering

23.10-Multicollinearity

23.11-Subset Selection

23.12-Parameter Estimates

24-SAS Predictive Modeling, Evaluation Metrics

24.1-Discrimination vs. Calibration (Article)

24.2-ROC Curve

24.3-Scoring Validation Data Set Using Code

24.4-Decile Calibration Plot

24.5-Kolmorgov-Smirnov (Article)

24.6-Feature Engineering

25-Extra Content

25.1-Top 5 SAS Certification Questions Answered

26-Bonus

26.1-Bonus Lecture

Course Categories

Popular Courses

SAS Programming Complete: Learn SAS and Become a Data Ninja

Description

What you'll learn

Requirements

Course Content

You May Like