SAS Online Intermediate Level by Elegant IT Services

ELEGANT IT SERVICES IN MARATAHAHALLI

SAS 9.1.3

PART-I

SAS/BASE
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
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 Compare
Proc Copy
Proc Summary
Proc Append

Proc Contents
Proc Delete
Proc Format
Proc Import
Proc Export

PART II ADVANCED
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

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 Columns Length
Joins
Constraints
Renaming A Table & Columns
Views

SAS/ACCESS
Working With Oracle
Working With Ms-Access
Working With Ms-Excel & Other Database Files.
DbLoad Procedure

SAS/GRAPH
Gchart Procedure
Vertical, Horizontal, Pie
Donut
G3d
Group,Subgroups
Gplot Procedure
Mutliple 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 & Call Symput
Including External Macros

SAS/STAT
Proc Univariate
Proc Corr
Proc Reg
Proc Anova
SAS/ODS
Creating Rtf File
Creating Html File
Creating Pdf File

PART-III (Only One Project)
CLINICAL PROJECT
BANKING PROJECT