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
+1 (415)-873 0245