Online Training

[Hardik]

Hello Students

I am offering SAS 9.1 Online Training With advance topics like DW, ETL and with a Clinical project. Interested students can reach me @ [email protected]

Starting Two new batches of SAS one-morning and one evening schedule. Please contact me for more details.

Course Contents

PART-I
BASE SAS
  Introduction To SAS System & Architecture
  History And Various Modules
  Features
  Variables & SAS Syntax Rules
  SAS Data Sets
  Data Set Options
  Operators
  If – Then Else Statement
  Where Statement
  Creating & Redefining Variables
  Reading Raw Data
  Infile Statement With Options
  Multiple Observations and Multiple Datasets.
  Input Styles
  SAS Functions
  Select Statement
  Do Loops
  Leave and Continue Statements
  Output Statement &  Put Statement
  Stop And Error Statements
  Array Statement
  Modifying And Combining Data Sets
  Updating Master Data Set
  Key Board Macros & Add Abbreviations
  Display Manager Commands
BASE SAS PROCEDURES
  Proc Sort
  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 Printto
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
  Rbreak Statement
  Tabulate Procedure
  One-Dimensional Tables
  Two-Dimensional Tables
  Obtaining A Total
  Analysis Variables with options
  Summary Statistics
SAS/ODS
  Creating Rtf File
  Creating Html File
  Creating Pdf File
  Creating Xml File

PART -II
ORACLE-SQL CONCEPTS
  Introduction
  History
  Features
  Sql Command Set
  Operators In Sql
  Order By Clause
  Group By Clause
  Having Clause 
  Distinct Clause
  Create and Insert
  Deleting,Populating And Updating
SAS/SQL
  Introduction  To SAS/SQL
  Features & Uses
  Terminology
  Data Types, Key Words, & Operators
  Functions, Predicates & Functions
  Formatting Output
  Group By Clause, Order By Clause & Having Clause
  Case Expression and Conditional Logic.
  Creating ,Populating & Deleting Tables
  Alter Table Statement
  Renaming A Table & Columns
  Changing Column’s Length
  Joins & Views
SAS/ACCESS
  Import & Export Procedures
  Importing data from Ms-Access & Ms-Excel
  Importing data from Oracle database
  DbLoad Procedure
SAS/GRAPH
  Gchart Procedure
  Vertical, Horizontal, Pie
  Donut
  Group,Subgroups
  Gplot  Procedure
  Mutliple Plots & Overlay
  Symbol Statement
  Title  and Footnote Statements
  Goptions
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/STAT
  Proc Univariate
  Proc Corr
  Proc Reg
  Proc Anova
SAS/WAREHOUSE ADMINISTRATOR
  Introduction To DW
  Relationship Between SAS And Data Warehousing
  Database Designing
  Types Of Schema
  Global Warehouse Designing Steps
SAS/ETL
  Introduction To ETL
  Application Of ETL In DW
  ETL Process Model Development In SAS With Project

PART-III (Only One Project)

CLINICAL PROJECT
BANKING PROJECT

Hardik