Using Macros in SAS

Creating a Macro in SAS
- Calling a SAS Macro
- Keyword parameters and Positional parameters in Macros
- Using %Macro, %Let, %Put, %Symput
- Using %If %Then %Do statements

Day 12 – Introduction to PROC SQL

• Group By and Having clauses in SQL
• - Using aggregate functions to summarize data in SQL
• - Using nested Where clause in SQL
• - Modifying datasets using Create Table Like, Create Table As, Alter Table and Update clauses

Day 13 – PROC SQL Continued

- Using SQL queries in SAS
- Queries to create a table and select values from a table
- Using SQL conditional statements (Where and Case When clauses)
- Order by clause in SQL to sort datasets

Replication all analysis and modeling techniques using R.

Predictive Modeling using R/Rattle

Replicating SAS Procedures in R

Introduction to using PROC FACTOR, PROC FASTCLUS, PROC CLUSTER

Basic Introduction to K-Means Clustering

Factor Analysis – Principal Components using SAS

Basic introduction to Multiple Linear and Logistic regression using SAS with real life data sets.

Basic introduction to credit scoring using Logit modeling. Key concepts of binary prediction like lift, KS, ROC curve, Gains charts etc are explained in these set of videos.

Basic Linear Regression – Part 1

Linear Regression – Part 2

Introduction to Logistic Regression – Part 1

Logistic Regression – Part 2

Logistic Regression – Part 3

Series of videos on Basic Stats using SAS

Hypothesis Testing – First Part

Hypothesis Testing – Second Part

Hypothesis Testing – Third Part

Round up and Revision – Basic Stats (Introduction to Excel Data Analysis Tool Pack)