SAS Programming Complete: Learn SAS and Become a Data Ninja

Udemy

Online

₹ 3099

Quick Facts

particular	details
Medium of instructions English	Mode of learning Self study	Mode of Delivery Video and Text Based

Course and certificate fees

Fees information

₹ 3,099

certificate availability

Yes

certificate providing authority

Udemy

The syllabus

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

Articles

Latest Articles

Basic Interview Questions For SAS 2024 Updated On 28 Dec, 2023

Trending Courses

Popular Courses

General Management Courses Public Health Courses Teaching and Education Courses Financial Management Courses Web Development Courses Mathematics Courses Data Science Courses Programming Courses Cyber Security Courses Digital Marketing Courses Law Courses Mechanical Engineering Courses Explore all courses

Popular Platforms

upGrad Courses Udemy Courses Edx Courses Swayam Courses Coursera Courses NPTEL Courses Futurelearn Courses Mindmajix Technologies Courses Vskills Courses IIT Kharagpur Courses Emeritus Courses IIT Kanpur Courses Explore all platforms

Learn more about the Courses

10 Reasons to Enrol Yourself in a Digital Marketing Course 8 Must-Have Skills for AWS Cloud Architects Planning to Upskill Yourself? Enrol for a Program in Data Science 25+ Tips for Improving Your Graphic Design Skills Top Universities in India Offering Cyber Security Courses 15+ Courses for Learning Data Mining How to Make a Career in the Field of Artificial Intelligence Top 10 Benefits Of Holding A Certification In Business Intelligence Which are the best certification courses for Photography in India A Beginner's Guide to Pursue Python Programming Want to Pursue a Career in Blockchain Technology? Here is all that you need to Know How Entrepreneurs Can Use Machine Learning to Make their Business Successful? The Scope of Artificial Intelligence in India Top 10 Online Courses for Travel Lovers 10 Best Certification Courses After Hospital and Healthcare Management

Open in App

Get the Careers360 App today!

And never miss an important update

Download Careers360 App

All this at the convenience of your phone

Regular Exam Updates
Best College Recommendations
College & Rank predictors
Detailed Books and Sample Papers
Question and Answers

Popular Searches