• Introduction to SAS System & Architecture
• History and Various Modules
• Features
• Variables & SAS Syntax Rules
• Sas Data Sets
• Data Set Options
• Operators
• Reading Raw Data
• Infile Statements with Options
• Working with External Files & Options
• Multiple Observations
• Input Styles
• Select Statement
• Leave and Continue Statements
• Retain Statement
• Creating & Redefining Variables
• Where Statement
• If-Then Else Statement
• Goto, Stop and Error Statements
• Output Statement, Put Statement
• Do Loops
• Array Statement
• Date Informats, Formats
• Date and Time Functions
• Modifying and Combining Data Sets
• Updating Master Data Set
• Key Board Macros & Add Abbreviations
• Display Manager Commands
• SAS Functions
• Finding Duplicate Observations

• Proc Print
• Proc Means
• Proc Freq
• Proc Plot
• Proc Chart
• Proc Compare
• Proc Copy
• Proc Summary
• Proc Append
• Proc Datasets
• Proc Contents
• Proc Delete
• Proc Format
• Proc Import
• Proc Export
• Proc Printto

• Introduction
• History
• Features
• Sql Command Set
• Operators in Sql
• Order By Clause
• Group By Clause
• Having Clause
• Distint Clause
• Create and Insert
• Deleting, Populating and Updating
• Sub Queries
• View and Joins

• Introduction to Sas/Sql
• Features
• Uses
• Terminology
• Data Types, Keywords and Operators
• Functions, Predicates
• Formatting Output
• Group By Clause
• Order By Clause
• Having Clause
• Case Expression and Conditional Logic
• Creating, Populating and Deleting Tables
• Constraints
• Alter Table Statement
• Changing Column’s Length
• Joins
• Constraints
• Renaming a Table and Columns
• Views

• Working with Oracle
• Working with MS-Access
• Working with MS-Excel and other Database files
• DbLoad Procedure

• Gchart Procedure
• Vertical, Horizontal, Pie
• Donut
• G3d
• Group, Subgroups
• Gplot Procedure
• Multiple Plots and Overlay
• Symbol Statement
• Title and Footnote statements
• Goptions

• 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
• Rbreak Statement
• Tabulate Procedure
• One-Dimensional Tables
• Two-Dimensional Tables
• Obtaining A Total
• Analysis Variables with Options
• Summary Statistics

• 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 & Call Symput
• Including External Macros

• Proc Univariate
• Proc Corr
• Proc Reg
• Proc Anova

• Creating Rdf File
• Creating Html File
• Creating Pdf File

• Introduction to DW
• Relationship between SAS and Data Warehousing
• Database Designing
• Types of Schema
• Global Warehouse Designing Steps

• Introduction to ETL
• Application of ETL in DW
• ETL Process Model Development in SAS with Project

• Clinical Project
• Banking Project

Yes, you get two kinds of discounts. They are group discount and referral discount. Group discount is offered when you join as a group, and referral discount is offered when you are referred from someone who has already enrolled in our training.

The trainer will give Server Access to the course seekers, and we make sure you acquire practical hands-on training by providing you with every utility that is needed for your understanding of the course.

The trainer is a certified consultant and has significant amount of experience in working with the technology.

Yes, we accept payments in two installments.

If you are enrolled in classes and/or have paid fees, but want to cancel the registration for certain reason, it can be attained within first 2 sessions of the training. Please make a note that refunds will be processed within 30 days of prior request.