SAS HANDS-ON LIVE ONLINE & CORPORATE TRAINING,JOB SUPPORT AND INTERVIEW SUPPORT BY REALTIME CERTIFIED FACULTY


FOR FREE DEMO contact us :
Email : raj@apex-online-it-training.com
Phone/WhatsApp : +91-(850) 012-2107
USA Number : 1+214-628-3894
Gtalk : raavi.sriraja@gmail.com
Blog: http://apex-it-online-trainings..in

Interview Questions and Answers, Recorded Video Sessions, Materials, Mock Interviews Assignments Will be provided


STATISTICAL ANALYSIS SYSTEM COURSE CONTENT (we can customize the Course Agenda as per your requirement)



Sas Course Curriculum



Faculty : 15+ yrs of Exp in IT, Corporate & Online Trainer
Duration : 40 Hours





PART-I

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



PART -II

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
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)
1. CLINICAL PROJECT
2. BANKING PROJECT

NOTE: 1.Free Course Material & Certification Guidance.
2. Fast Track & Weekend Batches Are Also There.
3. Online Training for Foreign Students



FOR More Details contact us :
Email : raj@apex-online-it-training.com
Phone/WhatsApp : +91-(850) 012-2107
USA Number : 1+214-628-3894
Gtalk : raavi.sriraja@gmail.com
Blog: http://apex-it-online-trainings..in