SAS Finance  Online Training

Table of Contents

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

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
  • Proc Rank
  • Proc Transpose

BANKING PROJECT