The first of which is creating a Correlation matrix in Excel. The file used can be downloaded  here –> car_sales.

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

Predictive Modeling using R/Rattle

Replicating SAS Procedures in R

Basic Introduction to K-Means Clustering

Factor Analysis – Principal Components using SAS

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

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)

Arrays in SAS

• SAS arrays are another way to temporarily group and refer to SAS variables. A SAS array provides a different name to reference a group of variables
• Array statement begins with keyword ARRAY followed by array name and N – number of elements within array
• _temporay_  option is used to create a temporary array

Looping in SAS

1. Functions in SAS:  Continued
   • Text function:
     •  Compress – Returns a character string with specified characters removed from the original string
     • Index – Returns the position of the specific character in a string
   • Use of upcase, lowcase and propcase functions in string comparison
   • Math / Stat functions: Like Int, Round, Sum, Mean etc
   • Difference between Mean value (or any aggregate function) of Proc Means / Summary and Mean function
2. Loops in SAS : Do Loops
   • Loops are used to iterate through every observation for specified number of times to obtain a desired result
   • Types of Loops:
     • Do Loop
     • Do While
     • Do Until
   • Default increments by 1
   • Can use BY to increment by any value other than 1

Functions in SAS (Continued)

1. Text Functions
   • Catx – to concatenate characters / strings with any delimiter. Cat is also a function used to concatenate characters / strings
   • Trim – to remove trailing blanks in a string
   • Tranwrd – Replaces all occurrences of a substring in a character string
   • Translate – Replaces specific characters in a character expression.
   • Do check out Compress and other Text functions like Upcase, Lowcase and Propcase
2. Date and Time Functions
   • Day – Returns the Day from a SAS date value
   • Month – Returns the Month from a SAS date value
   • Year – Returns the year from a SAS date value
   • Week – Returns the week number from a SAS date value (Try weekday function)
   • Mdy – Concatenates Month, Day and year into a date value
   • Today – Returns current system date
   • Datdif – Difference between 2 dates in days
   • Yeardif – Difference between 2 dates in years
   • INTCK – Returns the number of interval boundaries of a given kind that lie between 2 dates.
   • INTNX – Increments a date value by a given time interval, and returns a date