SAS course content & Material

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
17.Business Interaction with Domain Functionality for Special Process
  • Inter Company Sales
  • Cash Sales & Rush Orders
  • Consignments
  • Make to order (MTO)
  • Make to Stock (MTS)\
18.  Data Dictionary
  • Reports
File nameDescriptionSizeRev.TimeUser
SelectionFile type iconFile nameDescriptionSizeRevisionTimeUser