Certified SAS Base Programmer 

Introduction

Objective Slide

Introduction to SAS

SAS Functions and Consumers of SAS

SAS Base Programmer Certification Exam

SAS Base Programmer Certification Exam Registration

Benefits of SAS Base Certification for Professionals

Benefits of SAS Base Certification for Employers

Thank You

Introduction

Objective Slide

Introducing SAS

Components of SAS software

SAS GUI Environment

SAS Program

SAS Program contd

SAS Program contd

SAS Library

SAS Library contd

SAS Library contd

SAS Library contd

SAS Library contd

SAS Library contd

SAS Data Sets

SAS Data Sets contd

SAS Data Sets contd

SAS Data Sets contd

SAS Data Sets contd

SAS Variable Attributes

SAS Variable Attributes contd

SAS Variable Attributes contd

SAS Variable Attributes contd

SAS Variable Attributes contd

SAS Variable Attributes contd

Summary

Thank You

Quiz

Introduction

Objective Slide

Creating SAS Data sets Instream method

Creating SAS Data sets Instream method contd

Creating SAS Data sets Instream method contd

Importing Raw Data files in SAS Data set

Importing Raw Data files in SAS Data set contd

Importing Raw Data files in SAS Data set contd

Importing Raw Data files in SAS Data set contd

Importing Raw Data files in SAS Data set contd

Importing Raw Data files in SAS Data set contd

Importing Raw Data files in SAS Data set contd

Column Pointer Control

Column Pointer Control contd

Column Pointer Control contd

Column Pointer Control contd

Column Pointer Control contd

Importing Raw Data files in SAS Data set

Reading non standard numeric data

Reading non standard numeric data contd

Reading non standard numeric data contd

Reading non standard numeric data contd

Reading non standard numeric data contd

Writing non standard numeric data contd

Writing non standard numeric data contd

Importing Raw Data files in SAS Data set

Importing Raw Data files in SAS Data set contd

Importing Raw Data files in SAS Data set contd

Importing Raw Data files in SAS Data set contd

Importing Raw Data files in SAS Data set contd

Importing Raw Data files in SAS Data set contd

Importing Raw Data files in SAS Data set contd

Importing Raw Data files in SAS Data set contd

Importing Raw Data files in SAS Data set contd

Importing Raw Data files in SAS Data set contd

Importing Raw Data files in SAS Data set contd

Importing Raw Data files in SAS Data set contd

Combining multiple Data Sets

Combining multiple Data Sets contd

Combining multiple Data Sets contd

Combining multiple Data Sets contd

Combining multiple Data Sets contd

Combining multiple Data Sets contd

Combining multiple Data Sets contd

Accessing an Excel Work Book using SAS

Summary

Quiz

Thank You

Introduction

Objective Slide

Exporting Data from SAS

Exporting SAS data set Using Proc Export

Exporting SAS data set Using Proc Export contd

Exporting SAS data set Using Proc Export contd

Controlling Observations to be Processed

Controlling Observations to be Processed contd

General Form of SAS Functions

SAS Date Value

SAS Date Value contd

SAS Date Value contd

SAS Date Value contd

SAS Date Value contd

SAS Date Value contd

SAS Date Value contd

SAS Date Value contd

SAS Date Value contd

SAS Time Functions

Statistical Analysis of SAS Variables

Statistical Analysis of SAS Variables contd

Statistical Analysis of SAS Variables contd

Summary

Quiz

Thank You

Introduction

Objectives Slide

Assignment Statements in DATA Step

Modifying Character Values with SAS Functions

Modifying Character Values with SAS Functions contd

Modifying Character Values with SAS Functions contd

Modifying Character Values with SAS Functions contd

Modifying Character Values with SAS Functions contd

Modifying Character Values with SAS Functions contd

Modifying Character Values with SAS Functions contd

Modifying Character Values with SAS Functions contd

Modifying Character Values with SAS Functions contd

Modifying Character Values with SAS Functions contd

Modifying Character Values with SAS Functions contd

Modifying Character Values with SAS Functions contd

Modifying Character Values with SAS Functions contd

Modifying Character Values with SAS Functions contd

Modifying Numeric Values with SAS Functions

Modifying Numeric Values with SAS Functions contd

Converting Datatypes Using SAS Functions

Converting Datatypes Using SAS Functions contd

Processing Data with Do Loops

Processing Data with Do Loops contd

Processing Data with Do Loops contd

Processing Data with Do Loops contd

Processing Data with Do Loops contd

Processing Data with Do Loops contd

Processing Data with Do Loops contd

Processing Data with Do Loops contd

SAS Arrays

SAS Arrays contd

SAS Arrays Different Ways of Specifying Dimensions

SAS Arrays Different ways of specifying elements contd

SAS Arrays contd

Summary

Quiz

Thank You

Introduction

Objectives Slide

Selecting Variables to be Processed

Modify Variable Attributes in DATA Step

SAS Expressions

Modifying Variables using Operators

Modifying Variables using Operators contd

Conditionally Execute SAS Statements

Conditionally Execute SAS Statements contd

Conditionally Execute SAS Statements contd

Conditionally Execute SAS Statements contd

Conditionally Execute SAS Statements contd

Conditionally Execute SAS Statements contd

Sorting Data

Sorting Data contd

Investigating SAS Libraries

Investigating SAS Libraries contd

Accumulate Column Totals in DATA Statement

Accumulate SUB Totals in DATA Statement contd

Accumulate SUB Totals in DATA Statement contd

Summary

Quiz

Thank You

Introduction

Objectives Slide

SAS Report

Creating a Basic Report

Creating a Basic Report contd

Specifying Titles and Footnotes in a Report

Creating Enhanced List and Summary Reports

Creating Enhanced List and Summary Reports contd

Creating Enhanced List and Summary Reports contd

Creating Enhanced List and Summary Reports contd

Creating Enhanced List and Summary Reports contd

Creating Enhanced List and Summary Reports contd

Creating Enhanced List and Summary Reports contd

Creating Enhanced List and Summary Reports contd

Creating Enhanced List and Summary Reports contd

Creating Enhanced List and Summary Reports contd

Creating Enhanced List and Summary Reports contd

Creating Enhanced List and Summary Reports contd

Creating Enhanced List and Summary Reports contd

Creating Enhanced List and Summary Reports contd

Creating Frequency Reports

Creating Frequency Reports contd

Creating Frequency Reports contd

Creating Frequency Reports contd

SAS Output Delivery System

SAS Output Delivery System contd

SAS Output Delivery System contd

Summary

Quiz

Thank You

Introduction

Objectives Slide

SAS LOG

Syntax Errors

Syntax Errors contd

Syntax Errors contd

Syntax Errors contd

Syntax Errors contd

Data Errors

Testing Your Program to Avoid Data Errors

Testing Your Program to Avoid Data Errors contd

Logical Programming Errors

Summary

Quiz

Thank You