Mastering SAS Programming

This video aims at explaining what PROC SQL and the tasks that can be performed using PROC SQL are. It also explains the terminologies of SQL and the Syntax of PROC SQL.

   •  Understand the use of PROC SQL and the tasks it can perform

   •  Understand the terminology and difference between SAS and SQL

   •  Understand the Syntax of PROC SQL

This video aims at explaining how to retrieve data from a single table using SELECT statement, and various clauses that can be used based on the requirement of data to be fetched.

   •  Understand the use of SELECT statement

   •  Understand various clauses use with SELECT statement

This video aims at explaining how to retrieve data from multiple tables and perform Inner and Outer Joins to join the tables and get the desired results.

   •  Understand the different types of Joins - Inner and Outer

   •  Understand SET operators -Union, Except, Intersect and Outer Union

This video aims at explaining PROC SQL views and how to create them. It also explains what DICTIONARY tables are and how to access them in SAS.

   •  Understand PROC SQL views and how to create them

   •  Understand DICTIONARY tables and how to access them

The aim of this video is to understand what SAS Macros are, its advantages, and where they are used. It also covers how Macros are defined using various statements and invoked.

   •  Understand what SAS Macro are in details and areas where they are used

   •  Learn the Syntax of defining Macros using %MACRO and %MEND statements and how to invoke Macros

This video will explain the concept of Macro variables and its various properties. It will cover what are local and global variables and differences between them. It also explains two types of variables - automatic and user defined macro variables.

   •  Understand what Macro variables are, its Syntax, and various properties

   •  Understand local and global variables and the differences between them

   •  Understand automatic and user-defined Macro variables. Their Syntaxes and various commands pertaining to them

This video aims at explaining the concept of Macro variables through practical examples and SAS code.

   •  Understand how to use automatic variables in SAS code, and commands to view all the automatic variables

   •  Understand user-defined variables in SAS code, how to create them, and use them through various commands

This video aims at explaining what Macro functions are, its uses, and the Syntax. It also explains various types of Macro functions like Strings and Text Macro functions, functions for performing arithmetic and logical operations and SYMBOLGEN system option.

   •  Understand Macro functions and its uses and Syntax

   •  Understand and use the various String and Text related Macro functions with code examples

   •  Understand and use various macro functions related to arithmetic and logical operations with code examples

This video aims at explaining various types of Macro programs for conditional processing, iterative processing, and parameter validation.

   •  Understand conditional processing in Macros using IF ELSE

   •  Understand iterative processing in Macros using DO, WHILE, and UNTIL

   •  Understand defining Macros with parameters - positional and keyword parameters

This video aims at explaining how to use PROC SQL with Macros. It explains the entire Syntax of PROC SQL with %PUT statement to write the value of macro variable.

   •  Understand the use of PROC SQL and its Syntax along, with examples

This video aims at explaining what statistics is, use of statistics and the two analytical methods - statistical and non-statistical analysis. It also explains the two categories of statistics - descriptive and inferential and the differences between the two.

   •  Understand what statistics is and its uses

   •  Understand the two analytical methods - statistical and non-statistical analysis

   •  Understand two categories of statistics - descriptive and inferential

This video aims at explaining what the areas are where statistics is widely used. It then explains the various important statistical terms used commonly.

   •  Understand the areas where statistics is widely used

   •  Understand the important statistical terms

This video aims at explaining the different types of variables in statistics. Broadly there are two types - numeric and categorical. It then explains further classification of numeric variables into continuous and discrete and categorical variables as ordinal, nominal and dichotomous.

   •  Understand the classification of variables into numeric and categorical

   •  Understand numeric variables and its types

   •  Understand categorical variables and its types

This video aims at explaining hypothesis testing which is an inferential technique and the two types of hypotheses - null and alternate. It then explains the step-by- step process to test any hypotheses along with an example.

   •  Understand what hypothesis testing is

   •  Understand null and alternate hypotheses

   •  Understand process of testing any hypotheses through example

This video aims at explaining the two categories of inferential statistics - parametric and non parametric tests. It then explains in detail various parametric tests like T-test, Anova, Chi-Square, and linear regression.

   •  Understand what are parametric and non parametric tests

   •  Understand parametric tests in detail -T-test, Anova, Chi-Square, and linear regression

This video aims at explaining the various procedures available in SAS to perform descriptive statistics like PROC PRINT, PROC CONTENTS, PROC MEANS, PRC FREQ, and so on

   •  Understand the SAS procedures in detail

This video aims at explaining what cluster and cluster analysis are. It then explains the types of cluster analysis techniques present.

   •  Understand what cluster and cluster analysis are

   •  Understanding supervised and unsupervised cluster analysis with different techniques

This video aims at explaining various cluster analysis procedures available. It then focusses on PROC CLUSTER procedure explaining its Syntax.

   •  Understand the various cluster analysis procedures like PROC ACECLUS, PROC DISTANCE, and so on

   •  Understand PROC CLUSTER and its Syntax, with detail about each statement used in the Syntax

This video aims at explaining the implementation of cluster analysis through SAS code example and how to use PROC CLUSTER to create clusters.

   •  Understand the example of SAS code and usage of PROC CLUSTER in SAS code

This video aims at explaining K-Means clustering and its Syntax. It then explains it in detail through SAS code using FISH dataset.

   •  Understand K-Means clustering and Syntax of PROC FASTCLUS

   •  Understand K-Means clustering through SAS code using FISH dataset

This video aims at explaining what decision trees are and how are they created. It also covers the Syntax of creating decision tree model using PROC DTREE statement.

   •  Understand decision trees and its components

   •  Understand Syntax of PROC DTREE to create decision tree model

   •  Understand the model through example, by creating decision tree in SAS code

This video aims at explaining what regression and dependent and independent variables are. It also explains binary and continuous variables and the different types of regression like linear and logistic regression, based on the dependent and number of independent variables.

   •  Understand what regression analysis is

   •  Understand binary and continuous variables

   •  Understand types of regression like linear (simple and multiple) and logistic

This video aims at explaining what linear regression and its Syntax are. It then explains types of linear regression - simple and multiple linear regression and how to do model interpretation.

   •  Understand linear regression and its Syntax in detail

   •  Understand types of linear regression - simple and multiple and their equations

   •  Understand model interpretation

This video aims at explaining the implementation of linear regression models through SAS code examples, using Electronic dataset and Regression dataset. It also explains how to interpret the models and derive outcomes out of it.

   •  Understand the example of SAS code for simple linear regression model and how to interpret model

   •  Understand the example of SAS code for multiple linear regression model and how to interpret model

   •  Understand regression better with Regression dataset

This video aims at explaining what logistic regression, its equation, model interpretation, and Syntax are. It also explains the difference between linear and logistic regression. It finally uses Cancer Remission dataset to build the model and interpret it in SAS code.

   •  Understand what logistic regression, its equation, and Syntax are

   •  Understand the differences between linear and logistic regression

   •  Understand the SAS code for logistic regression model using the Cancer Remission dataset

This video aims at explaining the various areas where time series analysis is done, and what are the uses for time series analysis.

   •  Understand the various datasets on which time series analysis is performed

   •  Understand the purpose of time series analysis

This video aims at explaining time series procedure in SAS with its Syntax, along with an e-commerce example.

   •  Understand the PROC TIMESERIES procedure

   •  Understand the Syntax of PROC TIMESERIES

   •  Understand various statements and options which can be used by PROC TIMESERIES

This video aims at explaining various time series options and their uses. It also explains formats and informats used in reading SAS date and date time values.

   •  Understand what the different options available in time series analysis are

   •  Understand informats available in SAS with examples

   •  Understand formats available in SAS with examples

This video aims at explaining four types of time series patterns - Trend, Seasonality, Random, and Cyclic.

   •  Understand Trend pattern with example

   •  Understand Seasonality pattern with example

   •  Understand Random and Cyclic pattern with example

This video aims at explaining the different time series models and then understanding ARIMA model in detail. It explains the three stages of ARIMA model and steps performed in all the three stages.

   •  Understand stationary and non-stationary time series

   •  Understand different time series analysis models

   •  Understand ARIMA model and its three stages

This video aims at explaining the ARIMA model through an example.

   •  Understand how to use PROC ARIMA procedure

   •  Understand how to make a series stationary

   •  Understand how to perform estimation and forecasting stage

This video aims at explaining what factor analysis and the steps involved in performing factor analysis are. It also explains the term factor and equation of common factor model.

   •  Understand factor analysis and various methods of performing factor analysis

   •  Understand the term factor and equation of common factor model

   •  Understand common factor analysis

This video aims at explaining PROC FACTOR procedure along with its Syntax. It also explains various options used with PROC FACTOR to perform factor analysis through an example.

   •  Understand the PROC FACTOR procedure and its Syntax

   •  Understand the various options which can be used with PROC FACTOR to perform factor analysis

   •  Understand the factor analysis through an example

This video aims at explaining PROC GPLOT procedure along with its Syntax. It also explains scatter plot and line plot through examples.

   •  Understand PROC GPLOT procedure along with its Syntax

   •  Understand scatter plot along with an example

   •  Understand line plot along with an example

This video aims at explaining PROC GCHART procedure and its uses. It also explains various charts that can be drawn using PROC GCHART. Also, understanding what PROC BOXPLOT is and how to create it.

   •  Understand PROC GCHART and its various uses

   •  Understand different charts that can be drawn using PROC GCHART through examples

   •  Understand PROC BOXPLOT procedure with an example