SAS - Other Course

BASE SAS

• Introduction To SAS System & Architecture

• History And Various Modules

• Features

• Variables & SAS Syntax Rules

• SAS Data Sets

• Data Set Options

• Reading Raw Data

• In file 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

• Go to, Stop And Error Statements

• Output Statement

• Do Loops

• Modifying And Combining Data Sets

• Updating Master Data Set

• Display Manager Commands

• SAS Functions

Base SAS Procedures

• Proc sort

• Proc Means

• Proc Print

• Proc Plot

• Proc Copy

• Proc Freq

• Proc Chart

• Proc Summary

• Proc Datasets

• Proc Append

• Proc Contents

• Proc Delete

• Proc Format

• Proc Import

• Proc Export

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

• Renaming A Table & Columns

• Alter Table Statement

• Changing Column Length

• Joins

• Constraints

• Views

SAS/ACCESS

• Working With Ms-Access

• Working With Ms-Excel

• Working With Oracle

• 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

• Automatic Variables

• Macros And Macro Variables

• Creating Macro Variables

• Using Macro Variables

• Creating Modular Code With Macros

• Invoking A Macro

• Macros With Conditional Logic

• Adding Parameters To Macros

• Using Various Procedures In Macros

• Macro Functions

• Including External Macros

SAS/STAT

• Proc Univariate

• Proc Corr

• Proc Reg

• Proc Anova

SAS/ODS

• Creating Rtf File

• Creating Pdf File

• Creating Html File

Project

• Banking Project

or

• Clinical Project