Sas Online Training @ Lowest Fee With Project

[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]