SAS Adv. Analytics or Predictive Modelling:-
SAS Base & Advanced Course:-
- Getting Started with SAS
- Working with SAS syntax
- Getting Familiar with SAS dataset
- Reading SAS datasets
- Reading SAS datasets
- Reading Excel worksheets
- Reading Delimited Raw data files
- Validating and cleaning data
- Manipulating data
- Combining SAS Datasets
- Enhancing Report (ODS systems)
- Summary Reports
- Controlling Input and Output
- Summarizing Data
- Reading Raw Data Files
- Data Transformations
- Processing Data iteratively
- Restructuring a Data set
- TRANSPOSE Procedure
SQL Procedure:
- Introduction to SQL procedure
- Basic Queries
- Displaying Query Results
- Sub queries
- SQL Joins
- Set Operators
- Creating Tables and views
- Interfacing SQL with Macro Language
- Managing Tables
- Use of SQL in Clinical Trials
Macro language (SAS Macro)
- Macro Variables
- Macro definitions
- Data Step and SQL Procedure
- Macro Programs
- Use of Macro language in Clinical Research
Free sessions :
SQL
EXCELL
Predictive Modelling:
I. Descriptive Statistics
Introduction to Statistics
Data Preparation
Discrete Distributions
Binomial, Poisson, Negative Binomial, Geometric and Hyper-Geometric Distributions.
Continuous Distributions
Normal, Uniform, Gamma, Beta of I and II kinds, Exponential, Cauchy Distributions.
Sampling Methods
II. Statistical Inference
Parametric tests
Non parametric Tests
III. Predictive Modeling technique
Simple Linear Regression (SLR)
IV. Multiple Linear regressions
V. Logistic Regression for Classification and Prediction
VI. Forecasting Technique (Time series Analysis)
VII. Multivariate Techniques