SAS:

The content of this course is designed, explained and demonstrated with examples by SAS professionals who all have come together for a single purpose; to share their experience and to help you become an effective SAS expert.

INTRODUCTION TO SAS

HOW SAS WORKS

NEED FOR SAS

WHO USES SAS

WHAT IS SAS?

OVERVIEW OF BASE SAS SOFTWARE

WRITING YOUR FIRST SAS PROGRAM

A SIMPLE PROGRAM TO READ RAW DATA AND PRODUCE A REPORT

ENHANCING THE PROGRAM

MORE ON COMMENT STATEMENTS

READING RAW DATA INTO SAS

READING DATA FROM A DATASET

WHAT IS RAW DATA

DEFINITIONS

DATA VALUES & etc.

SET STATEMENT OVERVIEW

AUTOMATIC VARIABLES IN SAS

INTERLEAVE MULTIPLE SAS DATA SETS

COMBINE MULTIPLE SAS DATA SETS & etc.

READING DATA FROM A DATASET

SAS INFORMATS AND FORMATS

INPUT SAS DATA SET FOR EXAMPLE

SELECTING OBSERVATIONS FOR A NEW SAS DATA SET

DELETING OBSERVATIONS BASED ON A CONDITION

ACCEPTING OBSERVATIONS BASED ON A CONDITION

COMPARING THE DELETE AND SUBSETTING IF STATEMENTS

USING SAS INFORMATS

INPUT STATEMENT

INPUT FUNCTION

INPUTN AND INPUTC FUNCTIONS

USING SAS FORMATS

FORMAT STATEMENT IN PROCEDURES

PUT STATEMENT

SAS FUNCTIONS

AN INTRODUCTION TO ARRAYS AND ARRAY PROCESSING

CATEGORIES OF FUNCTIONS

SAS CHARACTER FUNCTIONS

FUNCTIONS THAT CHANGE THE CASE OF CHARACTERS

UPCASE

LOWCASE

WHY DO WE NEED ARRAYS?

BASIC ARRAY CONCEPTS

ARRAY STATEMENT

ARRAY REFERENCES

VARIABLE NAME ARRAY REFERENCE

BY - GROUP PROCESSING

OVERVIEW OF METHODS FOR COMBINING SAS DATA SETS

DEFINITIONS FOR BY-GROUP PROCESSING

BY-GROUP PROCESSING

BY VALUE

BY GROUP

DEFINITIONS

CONCATENATING

INTERLEAVING

ONE-TO- ONE READING OR ONE-TO-ONE MERGING

SAS PROCEDURES

INTRODUCTION TO PROC SQL

THE ANATOMY OF A PROC

THE PROC STATEMENT

THE PROC STATEMENT

TITLE AND FOOTNOTE STATEMENTS

WHY LEARN PROC SQL?

SELECT STATEMENT

THE SELECT STATEMENT SYNTAX

A SIMPLE PROC SQL

AN INTRODUCTION TO SAS MACROS

THE OUTPUT DELIVERY SYSTEM (ODS)

SAS MACRO OVERVIEW

TRADITIONAL SAS PROGRAMMING

THE SAS MACRO LANGUAGE

MACRO LANGUAGE COMPONENTS

CREATING VARIOUS TYPES OF REPORTS LISTING OUTPUT

OTHER DESTINATIONS

HTML

PDF AND POSTSCRIPT

RTF FILES