Brochure
Enquire
- 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!)
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
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
Popular Articles
prev
next
