SAS Programming Complete: Learn SAS and Become a Data Ninja

Udemy

Online

₹ 3099

particular

details

                                    Medium of instructions
                                    English

                                    Mode of learning
                                    Self study

                                    Mode of Delivery
                                    Video and Text Based

Introduction

SAS Enterprise Guide, SAS Studio, WPS ***very important***
How to Find, Install, and Use SAS Studio/SAS OnDemand For Academics
How to Find, Install, Register for, Use, and Upload Data-sets with WPS
All the Data-sets are attached to this Lecture!
Common Problems With Install/Upload/Videos (Watch for Best Course Experience!)

Importing

Import .txt
Import .csv
Import .XLSX
Quiz for Importing

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

Data Step vs. Proc Step
SAS Syntax
Manually Creating Data with R, Python, and SAS

Working with Data

Data Set Options
What if your data is separated by a dot or something else? (delimiters)
Reading data instream in data step (typing data right into coding area)
Reading DATES in data
Creating Variables/Calculations
More on Creating New Variables
Automatic Variables
Filtering Observations (so only some data show up)
Intuition For If-Then/Else and Do, Do-While, Do-Until
If-then Conditional Logic
DO Iterative Loop and Variations (DO WHILE, DO Until)
More on DO Group Processing (without index/counter variable)
More on the WHERE Expression/Statement
IF vs. WHERE
Sorting Observations (PROC SORT and BY statements)
Merging Two Data Sets
Using SET statement to Merge
Data Reduction and Cleaning your Data
LENGTH statement
Creating a Counting (Enumeration) Variable
Data Section Quiz
Assignment 0.5: Integration Assignment 0.5

Back to Importing

Importing SPSS file with SAS language

Input Types and Informats + User - Defined formats

List Input
Column Input
Formatted Input And Informats
User Defined Formats
Informats/Formats and SAS Input Style Quiz

Arrays

Arrays 1 (Recoding Variables)
Arrays 2 (Constructing new variables)

SAS Functions

Understanding SAS Functions
RAND Function (producing a sample with distribution of your choice)
LENGTH, LENGTHN, LENGTHC functions (are you working with a large data set?)
TRIM function (want to get rid of trailing blanks?)
COMPRESS Function (remove characters from string, and all types of blanks)
Input and Put Functions
CATX function
SCAN function
Help Me Understand Your Needs
Coalesce function
Verify function
Substr function
Functions Quiz

Assignments

Integration Assignments
Integration of Skills 1
Integration of Skills 2
Ratings/Reviews

Advanced Techniques - Flexibility and Efficiency

Flexible Programming 1 - Combining multiple raw data files vertically

Visual Representation of Data

Scatter Plot
Bar Graph

Statistical Analysis

Some information for this section
T-test independent samples overview (example)
Doing an Independent samples t-test analysis
Chi-square independence overview (example)
Doing a Chi-square (independent groups) analysis

Statistical Analysis- Part 2 (Linear and Multiple Regression)

Refresh Your Memory - Regression Edition
Performing the Linear Regression
Performing Multiple Regression

Case Studies

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

SQL Fundamentals

SQL Syntax
WHERE Clause
SELECT statement and Columns
CASE Logic
Summary Functions
SAS SQL Assignment 1
SAS SQL Assignment 1 Solution

SAS SQL and Joining

How to Perform an Inner Join
How to Join 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

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

Practical Applications of SAS SQL

How to Compare Tables with SAS SQL
Finding Duplicate Observations
Only Display Unique Records/Rows
Customize the way you Sort
How to Update a Table Under Certain Conditions with SAS SQL
SAS SQL Assignment 4
SAS SQL Assignment 4 Solution

Fundamentals of utilizing SAS Indexes

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

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)
Creating a Macro variable (helps you modify data easier)
Macro Programs Intro
Creating a Macro Example 1 (greater flexibility, +useful for repetitive coding)
Creating a Macro Example 2 (unique sales reports for different days)
Creating a Macro Example 3 (calculating average sales for multiple years)
Debugging Options
Storing Macros (External)
Macro Assignment 1
Brainstorming for Logistic Macro Case Study
Logistic Macro, Case Study, Part 1
Logistic Macro, Case Study, Part 2
Logistic Macro Case Study Assignment

SAS Predictive modelling using Logistic Regression, Introduction

Data sets used for Predictive Modeling Sections
Business Applications of Predictive Modeling
Analytics Challenges
The Major Steps in Predictive Modeling
Intuitive understanding of Logistic Regression

SAS Model - Predictive Modelling, Understanding the Problem and the Data

Problem Statement/Hypothesis Generation
Data Audit
Univariate Analysis
Bivariate Analysis
Important Housekeeping
Update your Code

SAS Predictive Modelling, Preparing the Input Variables

Sources, Patterns and Mechanisms of Missing Data
Evaluating Missing Data Patterns with SAS
3 Phase Multiple Imputation Process using SAS
Some additional code for PROC MI
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

SAS Predictive Modelling, Evaluation Metrics

Discrimination vs. Calibration (Article)
ROC Curve
Scoring Validation Data Set Using Code
Decile Calibration Plot
Kolmorgov-Smirnov (Article)
Feature Engineering

Extra Content

Top 5 SAS Certification Questions Answered

Bonus

Bonus Lecture

Popular Courses

Popular Platforms

Popular Searches

SAS Programming Complete: Learn SAS and Become a Data Ninja

Online

₹ 3099

Quick Facts

Course and certificate fees

Fees information

certificate availability

certificate providing authority

The syllabus

Introduction

Importing

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

Working with Data

Back to Importing

Input Types and Informats + User - Defined formats

Arrays

SAS Functions

Assignments

Advanced Techniques - Flexibility and Efficiency

Visual Representation of Data

Statistical Analysis

Statistical Analysis- Part 2 (Linear and Multiple Regression)

Case Studies

SQL Fundamentals

SAS SQL and Joining

Working with Tables using SAS SQL

Practical Applications of SAS SQL

Fundamentals of utilizing SAS Indexes

Macro Facility Fundamentals

SAS Predictive modelling using Logistic Regression, Introduction

SAS Model - Predictive Modelling, Understanding the Problem and the Data

SAS Predictive Modelling, Preparing the Input Variables

SAS Predictive Modelling, Evaluation Metrics

Extra Content

Bonus

Articles

Popular Articles

Latest Articles

Trending Courses

Popular Courses

Popular Platforms

Learn more about the Courses

Thank You!

Download the Careers360 App on your Android phone