SAS Course

by Vibrant Technologies & Computers

Module

Title

Contents

Module 1:

INTRODUCTION TO SAS

Introduction
Need For Sas
Who Uses Sas
What Is Sas?
Overview Of Base Sas Software
Data Management Facility
Structure Of Sas Dataset
Sas Program
Programming Language
Elements Of The Sas Language
Rules For Sas Statements
Rules For Most Sas Names
Special Rules For Variable Names
Types Of Variables
Data Analysis And Reporting Utilities

Module 2:

HOW SAS WORKS

Writing Your First Sas Program
A Simple Program To Read Raw Data And Produce A Report
Enhancing The Program
More On Comment Statements
Internal Processing In Sas
How Sas Works
The Compilation Phase
The Execution Phase
Processing A Data Step: A Walkthrough
Creating The Input Buffer And The Program Data Vector
Writing An Observation To The Sas Data Set
Four Types Of Sas Libraries

Module 3:

READING RAW DATA INTO SAS

What Is Raw Data
Definitions
Data Values
Numeric Value
Character Value
Standard Data
Nonstandard Data
Numeric Data
Character Data
Choosing An Input Style
List Input
Modified List Input
Column Input
Formatted Input
Named Input
Instream Data
Creating Multiple Records From Single Input Row
Reading Data From External Files
Reading Blank Separated Values (LIST Or Free Form Data):
Reading Raw Data Separated By Commas (.Csv Files):
Reading In Raw Data Separated By Tabs (.Txt Files):
Using Informats With List Input
Supplying An Informat Statement With List Input
Using List Input With Embedded Delimiters
Reading Raw Data That Are Aligned In Columns:
Method 1: Column Input
Method 2: Formatted Input
Using More Than One Input Statement: The Single Trailing @

Module 4:

READING DATA FROM A DATASET

Introduction
Set Statement Overview
Automatic Variables In Sas
Interleave Multiple Sas Data Sets
Combine Multiple Sas Data Sets
Creating & Modifying Variables
Creating Multiple Datasets In A Single Data-Step
Subsetting Observations
Conditional Sas Statements
Logical And Special Operators
The Sas Supervisor And The Set Statement
Efficiency And The Set Statement
Know Your Data
Set Statement Data Set Options
Drop And Keep Options
Rename Option
Firstobs And Obs Options
In Option -
Where Option -
Other Set Statement Options
End Option
Key Option
Nobs Option
Point Option
Do Loops And The Set Statement
Introduction To Retain Statement

Module 5:

READING DATA FROM A DATASET

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
Methods Of Creating New Data Sets With A Subset
Subsetting Records From An External File With A Subsetting If Statement
Subsetting Observations In A Data Step With A Where Statement
Subsetting Observations In A Proc Step With A Where Statement
Subsetting Observations In Proc Sql
Difference Between If And Where

Module 6:

SAS INFORMATS AND FORMATS

Overview
Using Sas Informats
Input Statement
Input Function
Inputn And Inputc Functions
Attrib And Informat Statements
Using Sas Formats
Format Statement In Procedures
Put Statement
Put Function
Putn And Putc Functions
Bestw. Format

Module 7:

SAS FUNCTIONS

Categories Of Functions
Sas Character Functions
Functions That Change The Case Of Characters
Upcase
Lowcase
Propcase
Functions That Remove Characters From Strings
Function: Compbl
Function: Compress
Functions That Search For Characters
Function: Anyalnum
Function: Anyalpha
Function: Anydigit
Function: Anypunct
Function: Anyspace
Function: Notalnum
Function: Notalpha
Function: Notdigit
Function: Notupper
Functions That Search Strings
Find And Findc
Index, Indexc, And Indexw
Functions To Verify Data
Function Verify
Functions That Extract Parts Of Strings
Function: Substr (ON The Left-Hand Side Of The Equal Sign)
Function: Substrn
Functions That Join Two Or More Strings Together
Function: Cat
Function: Cats
Function: Catt

Module 8:

AN INTRODUCTION TO ARRAYS AND ARRAY PROCESSING

Why Do We Need Arrays?
Basic Array Concepts
Array Statement
Array References
Variable Name Array Reference
Using Array Indexes
One Dimension Arrays
Multi-Dimension Arrays
Temporary Arrays
Sorting Arrays Determining Array Bounds: Lbound And Hbound Functions
When To Use Arrays
Common Errors And Misunderstandings
Invalid Index Range

Module 9:

BY - GROUP PROCESSING

Definitions For By-Group Processing
By-Group Processing
By Value
By Group
First.Variable And Last.Variable
Modifying Sas Data Sets: Examples.
Invoking By-Group Processing
Preprocessing Input Data For By-Group Processing
Sorting Observations For By-Group Processing
Indexing For By-Group Processing
How The Data Step Identifies By Groups
Processing Observations In A By Group
How Sas Determines First.Variable And Last.Variable
Processing By-Groups In The Data Step
Overview

Module 10:

OVERVIEW OF METHODS FOR COMBINING SAS DATA SETS

Definitions
Concatenating
Interleaving
One-To- One Reading Or One-To-One Merging
Match-Merging
Updating
Modifying
Definitions For Reading, Combining, And Modifying Sas Data Sets
Reading A Sas Data Set
Combining Sas Data Sets
Modifying Sas Data Sets
Overview Of Tools
Reading Sas Data Sets
Reading A Single Sas Data Set
Reading From Multiple Sas Data Sets
Combining Sas Data Sets: Basic Concepts
One-To-One
One-To-Many And Many-To-One
Many-To-Many
Access Methods: Sequential Versus Direct
Sequential Access
Direct Access
One-To-One Reading

Module 11:

SAS PROCEDURES

Introduction
The Anatomy Of A Proc
The Proc Statement
Title And Footnote Statements
By Statement
Label Statement
Format Statement
Run Or Quit Statement
Description Of Data Used In Reports
Sas Reporting Procedures
Procs For All That Detail
Using Proc Print
Using Proc Sql
Proc Report
Procs That Summarize
Using Proc Chart
Using Proc Freq
Using Proc Means
Using Proc Univariate
Introduction To Proc Tabulate

Module 12:

INTRODUCTION TO PROC SQL

Introduction
Why Learn Proc Sql?
Select Statement
The Select Statement Syntax
A Simple Proc Sql
A Complex Proc Sql
Limiting Information On The Select
Creating New Variables
The Calculated Option On The Select
Using Labels And Formats
The Case Expression On The Select
Additional Select Statement Clauses
Remerging
Remerging For Totals
Calculating Percentage

Module 13:

AN INTRODUCTION TO SAS MACROS

Introduction
Sas Macro Overview
Traditional Sas Programming
The Sas Macro Language
Macro Language Components
Macro Variables
Macro Statements
Macro Processor Flow
Automatic Macro Variables
Macro Debugging Options
What Is A Macro?
Defining And Using Macros
Positional Macro Parameters
Keyword Macro Parameters

Module 14:

THE OUTPUT DELIVERY SYSTEM

Introduction
Creating Various Types Of Reports Listing Output
Other Destinations
Html
Pdf And Postscript
Rtf Files
Microsoft Excel
Adding Style To Your Reports
Locate Existing Styles
Ods Style= Option
Customize Your Reports
Ods Select; And Ods Exclude;
Other Customizations