# Advanced Analytics & Tools Training

Your own pace, Your own Time

## Video Library

Complete recorded sessions of Base and Advanced SAS programming alongwith Basic Analytics are uploaded. Click on the links for the YouTube Video link and brief writeups. All YouTube videos are available in HD format, resolution option can be used to set it to 720p to enable best experience.

Video Library contains day wise topics covered in video segments between 30 mins and 2 hours each. Topics covered range from Introduction to Base SAS and using SAS to build basic regression models including linear and logistic.

## Training Videos

Base and Advaced SAS programming including Basic Analytics using SAS.

SAS ProgrammingIntro to Libraries, Data step and Proc step in SAS PROC Steps PROC CONTENTS PROC PRINT PROC MEANS Options - PROC CONTENTS DATA STEPS (Keep and Drop Options, Obs & First Obs) PROC PRINT (Options including Labels, Obs and "n") Conditional Statements in SAS (WHERE and IF Statements) Exercises and Case Studies Sorting Datasets (PROC SORT and it's Options) PROC PRINT using BY and SUM (Aggregate functions) PROC APPEND and options MERGE Statement and it's options (Inner, Exact, Right inner etc.) PROC MEANS - Other options and Statement Day 6Take a break, practice all the above!PROC FREQ and Options PROC SUMMARY Introduction to Functions in SAS Functions in SAS (Continued) Text Functions (CATX, TRIM, TRANWRD, TRANSLATE etc.) Date and Time functions (INTCK, INTX, DAY, MONTH, MDY etc.) Functions in SAS (Continued) TEXT Function (COMPRESS, INDEX etc.) Math and Stat functions like INT, ROUND, SUM , MEAN etc. Looping in SAS (DO, DO WHILE, DO UNTIL etc.) Arrays in SAS Day 11Second Break - Practice Session!SQL Statements GROUP BY and HAVING clauses Aggregate Functions CREATE TABLE, ALTER and UPDATE Statements SQL Conditional Statements ORDER BY Creating a Macro in SAS Calling a Macro Using %Macro, %LET, %PUT, %SYMPUT etc.

Basic and Advanced AnalyticsIntroduction to Basic Stats Types of Variables Central Limit Theorem P value Approach Hypothesis Testing using SAS Introduction to Simple and Multiple Linear Regression GLM Models Logistic Regression Introduction to Cluster Techniques (K- Means, Ward's Method) Distance Methodologies Hierarchical and Non-Hierarchical Procedures Factor Analysis Principal Components using PROC FACTOR in SAS All above procedures using free/open source software R Introduction to R/Rattle platform

Analytics Webinars UploadedDecomposing a time series (4 components) Single, Double and Triple Exponential Holt's Linear Model Differencing and building Winters Model in Excel Holt's Winter model in Excel Introduction to Credit Scoring Credit Scoring using Logistic Regression (Logit Model) Using IBM SPSS Model Validation Calculating KS, Gain, Lift and ROC statistics using excel Basic introduction to R Statistical Package Using R without programming - Rattle Building models and analysing data using Rattle Opening and Saving models using Rattle