Live Lecture
· What is SAS Programming?
· Components of SAS Programming
· Building Blocks of SAS Programming
· Features of SAS Programming Language
· SAS Windows
· Data Libraries in SAS Programming
· SAS Application
· Future Scope in SAS
· SAS v/s R v/s Python
· Advantages of SAS
· Disadvantages of SAS
· Practical Exercise
Live Lecture
· Access Descriptor
· Browsing Data
· Column
· Column Function
· Data Type
· SAS Data Value
· SAS Database
· Database Management System (DBMS)
· Engine
· File
· Format
· Index
· Informat
· Libref
· Member
· Member name
· Member type
· Missing Value
· Observation
· PROC SQL View
· Record
· Relational Database Management System (RDBMS)
· Row
· SAS data file
· SAS data library
· SAS data set
· SAS data view
· Structured Query Language (SQL)
· Table Alias
· Table Lookup
· Target Variable
· Variable
· View
· Practical Exercise
Live Lecture
· Multivariate Analysis
· Business Intelligence
· Predictive Analytics
· Creating Safe Drugs & Clinical Research and Forecasting
· Practical Exercise
Live Lecture
· What is SAS Software?
· Types of SAS Software
· SAS for Windows
· SAS Enterprise Guide (EG)
· SAS Enterprise Miner (EM)
· SAS STAT Software
· Practical Exercise
Live Lecture
· Introduction
· Features
· Comparison with the SAS DATA Step
· Advantages
· Disadvantages
· Practical Exercise
Live Lecture
· What is SAS Simulation Studio?
· How Does Simulation Studio Function
· Features of SAS Simulation Studio
· Simulation Studio Graphical User Interface (GUI)
· Applications of SAS Simulation Studio
· Practical Exercise
Live Lecture
· What is SAS Macro?
· Benefits of Using SAS Macro
· Components of SAS Macro Code
· Functions of SAS Macros
· Practical Exercise
Live Lecture
· SAS Installation
· Steps in SAS Environment
· Practical Exercise
Live Lecture
· What is SAS User Interface?
· SAS Windows
· Code Auto Completion
· Executing SAS Program
· Result Window
· Program Table
· Practical Exercise
Live Lecture
· SAS Program Structure
· SAS DATA Step
· SAS PROC Step
· SAS OUTPUT Step
· Difference Between DATA Step and PROC Step
· Practical Exercise
Live Lecture
· What is SAS Data Set?
· Parts of SAS Data Set
· Special SAS Data Set
· SAS Built-in Data Set
· Practical Exercise
Live Lecture
· Sorting in SAS
· SAS PROC Sort Ascending Order
· SAS PROC Sort Descending Order
· BY Statement
· Practical Exercise
Live Lecture
· What is SAS Merge?
· Examples of SAS Merge Datasets
· When Matching is Not Perfect
· IN= Variables
· Practical Exercise
Live Lecture
· Instream Data
· Entering data for more than one case on the same line
· Reading data from external files
· Reading blank separated values ( list or free-form data)
· Reading raw data separated by commas (.csv files)
· Reading in raw data separated by tabs (.txt files)
· Practical Exercise
Live Lecture
· PROC Export Statement
· Writing a CSV file
· Writing a Tab Separated File
· Practical Exercise
Live Lecture
· What is a Variable in SAS?
· Creating SAS Variable
· SAS Variable Properties
· Practical Exercise
Live Lecture
· What is FIRST. & LAST. Variables in SAS?
· How FIRST. & LAST. Variables works
· Selecting FIRST. Variable in SAS
· Selecting Last. Variable in SAS
· How to calculate Cumulative Score in BY Group
· Practical Exercise
Live Lecture
· Introduction to SAS Operators
· Types of Operators in SAS
· SAS Arithmetic Operators
· SAS Logical Operators
· SAS Comparison Operators
· Order of Precedence of Operators
· Practical Exercise
Live Lecture
· SAS Syntax Statements
· SAS Variable Names
· SAS Data Set
· SAS File Extensions
· SAS Comments
· Practical Exercise
Live Lecture
· What is SAS Format?
· Built-in Format
· User-defined Format
· Practical Exercise
Live Lecture
· What is String in SAS?
· Declaring String Variables
· SAS COMPBL Function
· SAS STRIP Function
· SAS COMPRESS Function
· SAS LEFT Function
· SAS TRIM Function
· SAS “CAT” Functions
· SAS SUBSTR Function
· SAS LOWCASE, UPCASE, and PROPCASE
· SAS LENGTH Function
· Practical Exercise
Live Lecture
· What is Array in SAS?
· SAS Array Operators
· SAS OF Operator
· SAS IN Operator
· Practical Exercise
Live Lecture
· SAS Functions
· Types of Functions in SAS
· SAS Arithmetic Functions
· SAS Character (String) Functions
· SAS Date and Time Functions
· SAS Truncation Functions
· Practical Exercise
Live Lecture
· What is SAS Concatenate Data Sets?
· Different Cases of Concatenating Data Sets
· Different Names of Variables
· Different Variable Attributes
· Different Number of Variables
· Practical Exercise
Live Lecture
· Subsetting Datasets in SAS
· SAS Subsetting Variables
· SAS Subsetting Observations
· Practical Exercise
Live Lecture
· Decision Making in SAS
· Decision Making Statements in SAS
· IF-THEN and IF-ELSE Statement
· IF-THEN-ELSE IF Statement
· IF-THEN-DELETE Statement
· Practical Exercise
Live Lecture
· What is SAS Histogram?
· SAS UNIVARIATE Procedure
· Components of the SAS HISTOGRAM statement
· SAS Histogram with Normal Curve
· SAS Histogram with Different Customizable Options
· Practical Exercise
Live Lecture
· What is Bar Chart in SAS?
· SAS Simple Bar Chart
· SAS Stacked Bar Chart
· SAS Clustered Bar Chart
· Practical Exercise
Live Lecture
· What is SAS Pie Chart?
· SAS PROC TEMPLATE Procedure
· Simple Pie Chart in SAS
· SAS Pie Charts with Data Labels
· Grouped Pie Chart in SAS
· Practical Exercise
Live Lecture
· What is SAS ODS (Output Delivery System)?
· Sending Results to the Web (SAS HTML Output)
· Creating Word Output in SAS
· Creating PDF Output in SAS
· Practical Exercise
Live Lecture
· What is a SAS Boxplot?
· PROC SGPANEL and SGPLOT Procedures
· Simple Boxplot in SAS
· SAS Boxplot in Vertical Panels
· SAS Boxplot in Horizontal Panels
· Practical Exercise
Live Lecture
· What is SAS Scatter plot?
· The PROC SGSCATTER Procedure
· SAS Simple Scatter Plot
· SAS Scatter Plot with Prediction Ellipse
· Scatter Matrix in SAS
· Practical Exercise
Live Lecture
· SAS Correlation Analysis
· SAS PROC CORR Procedure
· SAS Correlation of all Variables
· SAS Correlation between Two Variables
· SAS Correlation Matrix
· Practical Exercise
Live Lecture
· Objective
· What is SAS Arithmetic Mean
· SAS PROC MEANS Procedure
· SAS Arithmetic Mean of an Entire Dataset
· SAS Arithmetic Mean of Specific Variables
· SAS Arithmetic Mean by Class
· Practical Exercise
Live Lecture
· Objective
· SAS Linear Regression
· SAS PROC REG Procedure
· SAS Linear Regression Between Two Variables
· Practical Exercise
Live Lecture
· Objective
· SAS T-TEST
· SAS PROC TTEST
· SAS One-Sample T-Test
· Two Sample T-Test SAS
· SAS Paired t-test
· Practical Exercise
Live Lecture
· Objective
· What is SAS Cross Tabulation
· Syntax for Cross Tabulation in SAS
· SAS Cross Tabulation of Two Variables
· SAS Cross Tabulation of n Variables
· Practical Exercise
Live Lecture
· Objective
· SAS Frequency Distribution
· SAS PROC FREQ Procedure
· Basic Usage of SAS PROC FREQ
· Missing Values in Frequency Table
· Ordering Values in the Table
· Practical Exercise
Live Lecture
· Objective
· SAS Standard Deviation
· Ways of Measuring SAS Standard Deviation
· SAS Standard Deviation Using PROC MEANS
· SAS Standard Deviation Using PROC SURVEYMEANS
· Practical Exercise
Live Lecture
· Objective
· What is a SAS Date?
· How to Read and Display Date and Time in SAS
· Defining SAS Date as a Character Variable
· Using SAS Informats and Formats
· Practical Exercise
Live Lecture
· Objective
· What is Hypothesis Testing in SAS
· Steps in SAS Hypothesis Testing
· Practical Exercise
Live Lecture
· Objective
· What is SAS ANOVA
· SAS PROC ANOVA Procedure
· SAS One Way ANOVA
· Practical Exercise
Live Lecture
· Objective
· What is Chi-Square Test in SAS
· SAS PROC FREQ Procedure
· One Way Chi-Square Test
· Two Way Chi-Square Test
· Practical Exercise
Live Lecture
· Objective
· What is SAS Bland Altman Analysis
· SAS PROC SGPLOT Procedure
· SAS Bland Altman Plot
· Practical Exercise
Live Lecture
· Objective
· What is SAS Repeated Measure Analysis
· The PROC GLM Procedure
· Applying Repeated Measure Analysis in SAS
· Practical Exercise
Live Lecture
· Objective
· What is SAS Fishers Exact Test
· The PROC FREQ Procedure
· Applying Fishers Exact Test in SAS
· Practical Exercise
Live Lecture
· Objective
· SAS Informat
· Reading SAS Numeric Format
· SAS Output Format
· SAS Numeric Format Examples
· Practical Exercise
Live Lecture
· Objective
· SAS Input Method
· Types of Input Methods in SAS
· Practical Exercise
Live Lecture
· Objective
· SAS SQL – PROC SQL SAS
· PROC SQL STATEMENTS
· Display Data Set
· Creating Dataset from Existing Data
· The WHERE Clause
· Updating the Dataset
· Deleting Rows from the Dataset
· Practical Exercise
Live Lecture
· Objective
· What is SAS Loop
· SAS DO Loop
· SAS DO WHILE and DO UNTIL
· Practical Exercise