Course is divided in to three segments.
- Excel basics and advanced featured for quick analysis.
- DATA SCIENCE USING SAS
-
- Introduction of SAS System & Architecture
- History and Various Modules of SAS
- Features of SAS
- Variables & SAS Syntax Rules
- SAS Data Sets
- Data Set Options
- Operators
- Reading Raw Data
- Infile Statement With Options
- Working with External Files & Options
- Multiple Observations
- Input Styles
- Select Statement
- Leave and Continue Statements
- Creating & Redefining Variables
- Where Statement
- If – Then Else Statement
- Goto, Stop And Error Statements
- Output Statement, Put Statement
- Do Loops
- Modifying And Combining Data Sets
- Updating Master Data Set
- Display Manager Commands
- SAS Functions
- An Introduction to Arrays and Array Processing
- Overview Of Methods for Combining SAS Data Sets
BASE SAS PROCEDURES
- Proc Sort
- Proc Print
- Proc Means
- Proc Freq
- Proc Plot
- Proc Chart
- Proc Copy
- Proc Summary
- Proc Append
- Proc Datasets
- Proc Contents
- Proc Delete
- Proc Format
- Proc Import
- Proc Export
Advanced SAS
SAS/SQL
- Introduction of SAS/ SQL
- Features of SAS/SQL
- Uses of SQL in SAS
- Terminology of SAS/SQL
- Data Types, Key Words, & Operators
- Functions, Predicates
- Formatting Output
- Group by Clause
- Order by Clause
- Having Clause
- Case Expression and Conditional Logic.
- Creating, Populating & Deleting Tables
- Alter Table Statement
- Changing Column’s Length
- Joins
- Constraints
- Renaming A Table & Columns
- Views
SAS/MACROS
- Macro Concepts
- Macros And Macro Variables
- Creating Macro Variables
- Using Macro Variables
- Creating Modular Code With Macros
- Invoking A Macro
- Adding Parameters To Macros
- Macros With Conditional Logic
- Using Various Procedures In Macros
- Automatic Variables
- Macro Functions
- Including External Macros
SAS/ODS
- Creating RTF File
- Creating Html File
- Creating PDF File
SAS/GRAPH
- Chart Procedure
- Vertical, Horizontal, Pie
- Group, Subgroups
- Plot Procedure
- Multiple Plots & Overlay
- Symbol Statement
- Title And Footnote Statements
SAS/REPORTS
- Frequency Report
- One-Way Frequency Report
- Cross Tabular Frequency Report
- Summary Statistics
- Creating a List Report
- Define Statement
- Order Usage and Group
- Printing Grand Totals
- Re-break Statement
- Tabulate Procedure
- One-Dimensional Tables
- Two-Dimensional Tables
- Obtaining A Total
- Analysis Variables with options
- Summary Statistics
SAS/STAT
- Proc Univariate
- Proc Corr
- Proc Reg
- Proc Anova
- Python
- Python Basics and data structure
- Regression, Segmentation, decision trees
- Intro to Machine learning algorithms