SAS Training – Base and Advance

SAS Base

Getting Started using SAS 

Getting Your Data into SAS 

History of SAS

Methods for getting data into SAS

Introduction SAS Modules

Entering data with view table Window

Rules for SAS Statements

Telling SAS where to find raw data

SAS Comments

Reading Raw data separated by spaces (LIST INPUT)

SAS Data set definition

Reading Raw data separated by commas

SAS Data Types

Reading Raw data separated by DSD method

Two Parts of SAS Program

FORMAT and INFORMAT data types

Difference between DATA and PROC Steps

Applying an INFORMAT Statement to LIST INPUT

SAS Windowing Environment

Reading character values that contain blanks &

Submitting the SAS Program

Format Modifiers

Reading SAS log and Output window

Reading raw data arranged in columns

Creating HTML Output

Reading selected variables data

SAS Data sets with SAS Explorer

Holding the data line through multiple iterations

of the DATA Step (@@)

Temporary Vs Permanent data set

INFILE Statement options (FIRST OBS= OBS=

MISSOVER SCANOVER)

Working with SAS dates

Working with your DATA  

Reading and Combining SAS Data Sets 

Creating and redefining variables

Modify DATA set by SET Statement

SAS Arithmetic operators

Interleaving Data sets using the Set statement

SAS Logical Operators

MERGE Statement

Using IF-THEN Statements

Combining DATA sets using ONE-ONE MERGE

Using IF-THEN/ELSE Statements

Combining DATA sets using ONE – MANY MERGE

RETAIN and SUM Statement

Combining SAS Data sets by adding observations.

SAS Arrays

Combining SAS Data sets by adding variables.

SAS DATA SET Options.

Difference between KEEP and DROP Statements.

UPDATE Statement

Update master file from a Transaction file (UPDATE STATEMENT).

       SAS PROCEDURES 

         Output Delivery System 

PROC Print

Concept of ODS

PROC Format

Tracing and Selecting Procedure Output

PROC Contents

Creating SAS Data Sets from Procedure Output

PROC Sort

Creating HTML Output

PROC Append

Create RTF Output

PROC Summary

Create PDF Output

PROC Means

Tracing and Selecting Output Object

PROC Compare

PROC Report

PROC Tabulate

PROC Transpose

PROC Export

SAS Advanced

SAS MACROS

SAS SQL

Macro Concepts

Introduction to SQL

Substituting Text with Macro Variables

SQL Statements

Creating modular code with Macros

Importance of PROC SQL

Macro FUNCTIONS

Overview of SELECT Statement

Adding parameters to Macros(Positional and Keyword Parameters)

SELECT and FROM Clause

Macro Variables (Automatic and user defined)

ORDER BY Clause

Macro PARMBUFF options

GROUP BY Clause

Storing Macro Definitions in External Files

HAVING clause

Macro AUTOCALL Library

Selecting the data from more than one Table

The Stored Compiled Macro Facility

Nested queries (sub query and IN LINE VIEWS)

Macro Conditional Execution (IF THEN ELSE)

SQL JOINS (Inner Joins, Outer Joins – Full Join, Right Join and Left Join)

Macro LOOPS (DO, DO WHILE, DO UNTIL)

SQL SET OPERATORS

Macro GLOBAL options

SQL VIEWS

Macro COMMENTS

INTEGRITY CONSTRAINTS

Macro INTERFACE FUNCTIONS

Creating and controlling the INDEXES

Pass-through Method

Additional SAS Topics

SAS GRAPH 

SAS STAT 

Overview

SAS/STAT software provides extensive

Procedures to produce Color plots, Charts,

Statistical capabilities with tools for both

Maps, Slides and other displays.

specialized and enterprise-wide analytical needs.

Enhance graphics Output

SAS/STAT includes techniques for scoring and

Types of Charts (Hbar, Vbar, Pie, Block,

multiple testing.

Donut, Star, pie3d, Hbar3d, Vbar3d charts)

PROC Univariate

PROC Chart

PROC Regression

PROC GChart

PROC Anova

PROC Plot

PROC Corr

PROC GPlot

PROC Freq