SAS Course Content
1.
SAS/BASE
·
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
·
Goto,
Stop And Error Statements
·
Array
Statement
·
Modifying
And Combining Data Sets
·
Updating
Master Data Set
·
Key
Board Macros & Add Abbreviations
·
Display
Manager Commands
2. 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
Import
·
Proc
Export
·
Proc
Printto
3. 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
·
Sub
Queries
·
Views
and Joins
4. SAS/SQL
·
Introduction To SAS/SQL
·
Features
·
Uses
·
Terminology
·
Data
Types, Key Words, & Operators
·
Functions,
Predicates
·
Deleting,
Populating And Updating
·
Sub
Queries
·
Views
and Joins
5.
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
·
Alter
Table Statement
·
Renaming
A Table & Columns
·
Changing
Column’s Length
·
Joins
·
Views
6.
SAS/ACCESS
·
Working
With Oracle
·
Working
With Ms-Access
·
Working
With Ms-Excel & Other Database Files.
·
DB
Load Procedure
7.
SAS/GRAPH
·
Gchart
Procedure
·
Vertical,
Horizontal, Pie
·
Donut
·
G3d
·
Group,
Subgroups
·
Gplot Procedure
·
Mutliple
Plots & Overlay
·
Symbol
Statement
·
Title And Footnote Statements
·
Goptions
8.
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
9.
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
10.
SAS/STAT
·
Proc
Univariate
·
Proc
Corr
·
Proc
Reg
·
Proc
Anova
11.SAS/ODS
·
Creating
Rtf File
·
Creating
Html File
·
Creating
Pdf File
·
Creating
Xml File
12. SAS/WAREHOUSE ADMINISTRATOR
·
Introduction
To DW
·
Relationship
Between SAS And Data Warehousing
·
Database
Designing
·
Types
Of Schema
·
Global
Warehouse Designing Steps
13. SAS/ETL
·
Introduction
To ETL
·
Application
Of ETL In DW
·
ETL
Process Model Development In SAS With Project
14. Billing
·
Billing
documents
·
Billing
plan
15. Finance Integration
·
Revenue
Account Determination
·
Credit Management
·
Rebate Processing
16. Material Management Integration Business
Interaction with Domain Functionality for Special Process
·
Stock posting
·
Stock Transfers
·
Third Party Sales
·
Individual Purchase Order
16. Business Interaction with Domain Functionality for Special Process
·
Inter Company Sales
·
Cash Sales & Rush Orders
·
Consignments
·
Make to order (MTO)
·
Make to Stock (MTS)
17. Data Dictionary
·
Reports
