Courses » SAS Course » SAS Online Training

 

SAS Online Training

 

SAS Online Course Content

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
• Reading Raw Data
• Infile Statement With Options
• Working With External Files & Options
• Multiple Observations
• Input Styles
• Select Statement
• Leave and Continue Statements
• Creating & Redefining Variables
• Where Statement
• If – Then Else Statement
• Goto, Stop And Error Statements
• Output Statement, Put Statement
• Do Loops
• Modifying And Combining Data Sets
• Updating Master Data Set
• Display Manager Commands
• SAS Functions

BASE SAS PROCEDURES

• Proc sort
• Proc Print
• Proc Means
• Proc Freq
• Proc Plot
• Proc Chart
• Proc Copy
• Proc Summary
• Proc Append
• Proc Datasets
• Proc Contents
• Proc Delete
• Proc Format
• Proc Import
• Proc Export

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
• Formatting Output
• Group By Clause
• Order By Clause
• Having Clause
• Case Expression And Conditional Logic.
• Creating ,Populating & Deleting Tables
• Alter Table Statement
• Changing Column’s Length
• Joins
• Constraints
• Renaming A Table & Columns
• Views

SAS/ACCESS

• Working With Oracle
• Working With Ms-Access
• Working With Ms-Excel
• DBLoad Procedure

SAS/GRAPH

• Gchart Procedure
• Vertical, Horizontal, Pie
• Donut
• G3d
• Group, Subgroups
• Gplot Procedure
• Multiple Plots & Overlay
• Symbol Statement
• Title And Footnote Statements
• Goptions

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

• Creating Rtf File
• Creating Html File
• Creating Pdf File