SAS ONLINE TRAINING @ AFFORDABLE COST

[Hardik K]

Dear Students

I am offering SAS Online Training with advance topics like DW, ETL and a Clinical project. Intereste d students can reach me at : [email protected]

Course Contents

PART-I
BASE SAS
  Introduct ion To SAS System & Architect ure
  History And Various Modules
  Features
  Variables & SAS Syntax Rules
  SAS Data Sets
  Data Set Options
  Operators
  If – Then Else Statement
  Where Statement
  Creating & Redefinin g Variables
  Reading Raw Data
  Infile Statement With Options
  Multiple Observati ons and Multiple Datasets.
  Input Styles
  SAS Functions
  Select Statement
  Do Loops
  Leave and Continue Statement s
  Output Statement &  Put Statement
  Stop And Error Statement s
  Array Statement
  Modifying And Combining Data Sets
  Updating Master Data Set
  Key Board Macros & Add Abbreviat ions
  Display Manager Commands

BASE SAS PROCEDURE S
  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 Statistic s
  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 Statistic s

SAS/ODS
  Creating Rtf File
  Creating Html File
  Creating Pdf File
  Creating Xml File

PART -II
ORACLE-SQL CONCEPTS
  Introduct ion
  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
  Introduct ion  To SAS/SQL
  Features & Uses
  Terminolo gy
  Data Types, Key Words, & Operators
  Functions, Predicate s & Functions
  Formattin g Output
  Group By Clause, Order By Clause & Having Clause
  Case Expressio n and Condition al Logic.
  Creating ,Populating & Deleting Tables
  Alter Table Statement
  Renaming A Table & Columns
  Changing Column’s Length
  Joins & Views

SAS/ACCESS
  Import & Export Procedure s
  Importing data from Ms-Access & Ms- Excel
  Importing data from Oracle database
  DbLoad Procedure

SAS/GRAPH
  Gchart Procedure
  Vertical, Horizonta l, Pie
  Donut
  Group,Subgroups
  Gplot  Procedure
  Mutliple Plots & Overlay
  Symbol Statement
  Title  and Footnote Statement s
  Goptions

SAS/MACROS
  Macro Concepts
  Macros And Macro Variables
  Creating Macro Variables
  Using Macro Variables
  Creating Modular Code With Macros
  Invoking A Macro
  Adding Parameter s To Macros
  Macros With Condition al Logic
  Using Various Procedure s In Macros
  Automatic Variables
  Macro Functions
  Including External Macros

SAS/STAT
  Proc Univariat e
  Proc Corr
  Proc Reg
  Proc Anova

SAS/WAREHOUSE ADMINISTR ATOR
  Introduct ion To DW
  Relations hip Between SAS And Data Warehousi ng
  Database Designing
  Types Of Schema
  Global Warehouse Designing Steps

SAS/ETL
  Introduct ion To ETL
  Applicati on Of ETL In DW
  ETL Process Model Developme nt In

SAS With Project

  PART-III (Only One Project)
  CLINICAL PROJECT
  BANKING PROJECT

Thanks
Hardik
Email : [email protected]