SAS Training For Banking Domain

Description

Hi,

We The I-SOLUTIONS are offering the best training in SAS & SAS-BI. We have the best trainer with over 10+ years of IT related experience.

We are the best in the industry. We offer the course cost effectively and maintain high quality of training.

Faculty: Mr. Ganesh (Having 10+yrs of real time experience Certified Faculty)

The course SAS 9.2 consists of the following modules:

SAS 9.2

 PART-I

SAS/BASE
 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 Statement 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

BASE SAS PROCEDURES
 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

 PART -II
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
 Sub Queries
 Views and Joins

SAS/SQL
 Introduction To Sas/Sql
 Features
 Uses
 Terminology
 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
 Constraints
 Alter Table Statement
 Changing Column’s Length
 Joins
 Constraints
 Renaming A Table & Columns
 Views

SAS/ACCESS
 Working With Oracle
 Working With Ms-Access
 Working With Ms-Excel & Other Database Files.
 DbLoad Procedure

SAS/GRAPH
 Gchart Procedure
 Vertical, Horizontal, Pie
 Donut
 G3d
 Group,Subgroups
 Gplot Procedure
 Mutliple Plots & Overlay
 Symbol Statement
 Title And Footnote Statemnts
 Goptions
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/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 & Call Symput
 Including External Macros
SAS/STAT
 Proc Univariate
 Proc Corr
 Proc Reg
 Proc Anova
SAS/ODS
 Creating Rtf File
 Creating Html File
 Creating Pdf File
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

NOTE: 1.FREE COURSE MATERIAL

2. SOFTWARE CD SAS 9.1.3 SP3

Website: www.i-solutions.co.in

For Further Details contact:

India Branch
i-Solutions,
#501, Sai Sushma Homes,
Near Karur Vysya Bank,
S.R.Nagar Police Station Road,
S.R.Nagar,Hyderabad-38,
Contact Person: Pallavi
info : chganesh@i-solutions.co.in
Phone : +91-9291202040

USA Branch
i-Solutions, Inc
2244, S Delaware Dr, Suite # 116,
Mount Prospect, IL – 60056.
Contact Person: Suresh
info : suresh@i-solutions.co.in
Phone : 847-312-5466, 646-434-5017