SAS Online Training Course Content

Introduction

• Introduction of SAS software
• Industries using SAS
• Components of SAS System
• Architecture of SAS system
• Functionality of SAS System
• Introduction of SAS windows

Working in the SAS Environment

• Functionality of SAS Windows
• Creating and managing SAS Libraries
• Overview of SAS Data states
• Types of Libraries
• Storing files temporarily and permanently
• Referencing SAS files

Creating database from raw data

• Steps to create a SAS dataset
• Creating SAS dataset using text file
• Creating SAS dataset using text file with delimiters
• Creating SAS dataset using structured text file
• Creating SAS dataset using unstructured text file
• Creating SAS dataset using Excel file
• Creating SAS dataset using Access file
• Creating SAS dataset using values inside the code

Creating AND Redefining variable

• Use with different conditional statements

Debugging Error Message

• DEBUGGING syntax ERROR MESSAGES

Output delivery system

• Concepts of output delivery system
• How ODS works and viewing output of ODS in different format
• HTML, RTF, PDF etc.

Combination the dataset

• One-o-one reading
• One to many
• Many to many
• Concatenation
• Interleaving
• Match merge

Functions

• Character function
• Numerical function
• Arithmetical function
• Mathematical function
• Date Function

Loops in SAS: Do Loops

• Do Loop
• Do While
• Do Until

Array

• Definition of array
• Example of array

Procedure in SAS

• Procedure Format
• Procedure Contents
• Procedure Options
• Procedure Append
• Procedure Compare
• Procedure Transpose
• Procedure Print
• Procedure Import
• Procedure Export
• Procedure Datasets
• Procedure Rank
• Procedure Tabulate
• Procedure Chart, Gchart, Gplot
• Procedure Report

Advance SAS Topics

Advance programming - Proc SQL

• Performing Queries Using PROC SQL
• Performing Advanced Queries Using PROC SQL
• Combining Tables Horizontally Using PROC SQL
• Combining Tables Vertically Using PROC SQL
• Creating and Managing Tables Using PROC SQL
• Creating and Managing Indexes Using PROC SQL

Advance programming - Macro

• Introduction to Macros
• Defining Macro facility
• Generating SAS code using Macros
• Placing text using Macro variable
• Passing Macro Elements
• Macro Execution Process
• Macro Statements

GRAPHS

• Introduction to graphics
• Introduction to graphics
• Types of Graphics (with latest models)
• Defining procedure Graphics

Extra

• Study material: Notes and Books
• Daily assignments with respect to chapter for hands on experience
• Interview preparation
• Resume preparation help