SAS BI Tools & Applications

• 1.SAS Enterprise Guide
• 2.SAS Data Integration Studio (ETL),
• 3.SAS Management Console,
• 4.SAS Web Report Studio
• 5.SAS OLAP cube Studio
• 6.SAS Add –In for Microsoft Office
• 7.SAS Information Map Studio
• 8.SAS stored proess

SAS DI Content Developer
Chapter 1 SAS®9 Enterprise Intelligence Platform and SAS® Data Integration Studio 1-1

• 1.What Is Business Intelligence?
• 2.Navigating in SAS Data Integration Studio
• 3.Chapter 2 Working under Change Management
• 4.What Is Change Management?
• 5.Repository Types
• 6.Using Change Management

Designing the Course Data Mart

• 1.Planning a Data Warehouse
• 2.Exercises

Building a Data Mart

• 1.Review of the Case Study
• 2.Define the Source Data
• 3.Define the Target Tables
• 4.Load the Target Tables
• 5.Exercises

Building an OLAP Cube

• 1.What Is OLAP
• 2.Building an OLAP Cube
• 3.Solutions to Exercises

Transformations for Slowly Changing Dimensions (Self-Study)

• 1.Defining Slowly Changing Dimensions
• 2.Using the SCD Type 2 Loader Transformation
• 3.Using the Fact Table Lookup Transformation

Job Scheduling

• 1.Scheduling SAS Data Integration Studio Jobs

SAS® Data Integration Studio and Data Quality

• 1.SAS and Data Quality
• 2.Data Validation Transformation
• 3.Apply Lookup Standardization Transformation (Self-Study
• 4.Create Match Code Transformation (Self-Study)
• 5.Chapter 10 Administering SAS® Data Integration Studio
• 6.Setup Tasks for SAS® Data Integration Studio

SAS OLAP CUBE STUDIO 9.1

Chapter 1 

• 1.Introduction to the SAS® Enterprise Intelligence Platform
• 2.SAS Business Intelligence Overview
• 3.Business Intelligence Information Consumers

Chapter 2 

• 1.Introduction to OLAP Cubes
• 2.Introduction to Online Analytical Processing
• 3.Overview of SAS OLAP Cube Studio
• 4.Registering Metadata
• 5.Exercises

Chapter 3 

• 1.Working with SAS OLAP Cubes Derived from Detail Tables
• 2.Creating a SAS OLAP Cube from a Detail Table
• 3.Generating Aggregations Using Cross-Dimensional Tuning
• 4.Setting Permissions Using SAS Management Console
• 5.Viewing a SAS OLAP Cube with SAS Enterprise Guide
• 6.Exercises

Chapter 4

• 1.Working with SAS OLAP Cubes Derived from Star Schemas
• 2.Creating an OLAP Cube from a Star Schema
• 3.Viewing a SAS OLAP Cube with SAS Web OLAP Viewer for Java
• 4.Solutions to Exercises

Chapter 5 

• 1.Monitoring and Tuning a SAS OLAP Cube
• 2.Building an Information Map from a SAS OLAP Cube
• 3.Creating a Report with SAS Web Report Studio
• 4.Exercises
• 5.Appendix A Working with SAS OLAP Cubes Derived from Summary Tables
• 6.Creating a SAS OLAP Cube from a Summary Table
• 7.Viewing a SAS OLAP Cube with Microsoft Excel
• 8.Appendix B SAS®9 Business Intelligence Training
• 9.SAS BI Content Developer

Chapter 6

• 1.Overview of the SAS Business Intelligence Applications
• 2.Introduction
• 3.SAS BI Java Applications
• 4.SAS BI Windows Applications
• 5.SAS BI Web Browser Applications

Chapter 7

• 1.Overview of the SAS Management Console
• 2.Introduction to the SAS Management Console
• 3.How the SAS Management Console Works
• 4.Introduction to the SAS Management Console Plug-Ins
• 5.Working with the User Interface

Chapter 8

• 1.Using SAS Data Integration Studio
• 2.SAS Data Integration Studio Overview
• 3.The SAS Data Integration Studio Interface
• 4.Adding Library Definitions
• 5.Using the Source Designer
• 6.Using the Target Designer
• 7.Using the Process Designer
• 8.Exercises

Chapter 9

• 1.Using SAS OLAP Cube Studio
• 2.Overview of SAS OLAP Cube Studio
• 3.SAS OLAP Cube Studio Interface

Chapter 10

• 1.Using the SAS Add-In for Microsoft Office
• 2.Overview of the SAS Add-In for Microsoft Office
• 3.Using the SAS Add-In for Microsoft Office
• 4.Exercises

Chapter 11

• 1.Using SAS Enterprise Guide
• 2.Investigating the Features of SAS Enterprise Guide
• 3.For Your Information v
• 4.Exploring SAS Enterprise Guide

Chapter 12

• 1.Using SAS Information Map Studio
• 2.Overview of the SAS Information Map Studio
• 3.Using SAS Information Map Studio
• 4.Exercises

Chapter 13 

• 1.Using SAS Web Report Studio
• 2.Overview of SAS Web Report Studio
• 3.Using SAS Web Report Studio
• 4.Exercises

SAS Clinical Course Content

• Project Management in Clinical Research
• What is Clinical Research?
• What is Protocol and role of Protocol

in Clinical Research?

• What is randomization and non randomization?

Which is playing main role in Clinical Research?

• What is SOP (Standard Operating Procedure)
• Role of DBMS team in Clinical Research
• What is CDM (Clinical Data Management)?
• Importance of CDM systems for data loading
• What is SAP (Statistical Analysis Plan)?
• Role of SAP in Clinical Research
• SAS Work Flow in Clinical Research
• Relation between SAS and DBMS
• Interaction between SAS with CDMs for data access
• Various report generation in Clinical Research

PART-I BASE SAS:

• Introduct ion To SAS System & Architect ure
• History And Various Modules
• 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 Observations and Multiple Datasets.
• Input Styles
• SAS Functions
• Select Statement
• Do Loops
• Output Statement & Put Statement
• top And Error Statement s
• Array Statement
  
• Modifying And Combining Data Sets
  
• Updating Master Data Set
  Key Board Macros & Add Abbreviat ions

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/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:

• Introduction To SAS/SQL
• Features & Uses
• Terminology
• 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