Data Science with SAS Training Course

  Lecture 1: Analytics overview
Live Lecture 
·       An introduction to the business analytics

·       The types of analytics

·       The areas of analytics

·       About analytical tools

·       About analytical techniques

·       Practical Exercise

  Lecture 2: Introduction to sas
Live Lecture 
·       An overview of the sas

·       Installation and introduction to sas,

·       Understanding different sas windows,

·       How to work with data sets,

·       Various sas windows like output,

·       Search, editor, log and explorer

·       Understanding the sas functions,

·       Which are various library types & programming files

·       The navigation in the sas console

·       About the sas language input files

·       What is data step? 

·       The proc step and data step

·       All about data step processing

·       The sas libraries

·       How to import and export raw data files,

·       How to read and subset the data sets

·       Practical Exercise

  Lecture 3: Combining and modifying datasets
Live Lecture 
·       Necessity of combining or modifying the data

·       Concatenating the datasets

·       About interleaving method

·       What is data manipulation?

·       Modifying the variable attributes

·       Practical Exercise

  Lecture 4: Sas operators and functions
Live Lecture 
·       Logical operator

·       Comparison operator

·       Arithmetic operator

·       Deploying different sas

·       Conditional statements

·       If/else, do while, do until

·       Practical Exercise

  Lecture 5 Compilation and execution
Live Lecture 
·       Input buffer,

·       Pdv (backend)

·       Missover

·       Practical Exercise

  Lecture 6: Creation and compilation of sas data sets
Live Lecture 
·       Understanding the delimiter,

·       Dataline rules,

·       Dlm,

·       Delimiter dsd,

·       Raw data files and execution

·       List input for standard data

·       Practical Exercise

  Lecture 7: Proc SQL
Live Lecture 
·       What is proc sql?

·       How to retrieve data from a table?

·       How to select columns in a table?

·       Retrieving the data from multiple tables

·       Selecting the data from multiple tables

·       Concatenating query results

·       Practical Exercise

  Lecture 8: Input statement and formatted input
Live Lecture 
·       Reading standard and non-standard numeric inputs

·       Column pointer controls,

·       Controlling while a record loads,

·       line pointer control/absolute line pointer control,

·       Single trailing,

·       Multiple in and out statements,

·       Dataline statement and rules,

·       List input method

·       Comparing single trailing

·       Double trailing

·       Practical Exercise

  Lecture 9: Sas format
Live Lecture 
·       Sas format statements: standard and user-written,

·       Associating a format with a variable,

·       Working with sas format,

·       Deploying it on proc data sets

·       Comparing attrib

·       Format statements

·       Practical Exercise

  Lecture 10: Sas graphs
Live Lecture 
·       Understanding proc gchart,

·       Various graphs,

·       Bar charts pie,

·       Bar and 3d and plotting variables with proc gplot

·       Practical Exercise

  Lecture 11: Sas macros
Live Lecture 
·       Need for sas macros

·       Macro functions

·       Sql clauses for macros

·       The % macro statement

·       The conditional statement

·       Practical Exercise

  Lecture 12: Basics of statistics
Live Lecture 
·       Introduction to the statistics

·       The statistical terms

·       Procedures in the sas for descriptive statistics

·       About hypothesis testing

·       About variable types

·       The hypothesis testing - process

·       The parametric and non - parametric tests

·       What are parametric tests?

·       What are non - parametric tests?

·       Parametric tests – the advantages and the disadvantages

·       Practical Exercise

  Lecture 13: Statistical procedures
Live Lecture 
·       The statistical procedures

·       What do proc means?

·       What is proc freq?

·       About proc univariate

·       About proc corr

·       About proc corr options

·       About proc reg

·       The proc reg options

·       The proc anova

·       Practical Exercise

  Lecture 14: Data exploration
Live Lecture 
·       Data exploration: an overview

·       What is data preparation? 

·       The general comments and observations on data cleaning

·       Data type conversion

·       Character functions

·       What is scan function?

·       About date/time functions

·       Missing value treatment

·       Various functions to handle missing value

·       Data summarization

·       Practical Exercise

  Lecture 15: Advanced statistics
Live Lecture 
·       An introduction to the advanced statistics

·       Introduction to the cluster

·       The clustering methodologies

·       What is k means clustering?

·       About the decision tree

·       The regression

·       The logistic regression

·       Practical Exercise

  Lecture 16: Working with time series data
Live Lecture 
·       An introduction to the working with time series data

·       Need for time series analysis

·       About the time series analysis — options

·       Reading date and datetime values

·       What is the white noise process?

·       The stationarity of a time series

·       The plot transform transpose and interpolating time series data

·       Practical Exercise

  Lecture 17: Designing optimization models
Live Lecture 
·       Introduction to the designing optimization models

·       About the need for the optimization

·       About optimization problems

·       What is proc optmodel?

·       Practical Exercise