Introduction to SAS Base Certificate

SAS Base Certificate

Introduction to SAS and SAS Fundamental Concepts

1. Overview of the SAS System
2. What Can SAS Do?
3. Components of the SAS Language
4. SAS Display Manager System
5. Basic Structure of SAS
6. Preliminary Concepts and Rules
7. SAS Resources

Accessing Data and Creating Data Structures

Accessing existing SAS Data sets

1. Introduction to SAS datasets
2. Accessing existing SAS data sets

Reading Raw data file

1. Introduction
2. Reading fixed-width files
3. DATA step processing
4. Reading delimited raw data files

SAS Expression and Functions    

1. Overview of Operators in SAS
2. Infix Operators in SAS
3. SAS expression & Conditional expression (WHERE and IF)
4. Numeric functions
5. SAS Time and Date
6. Character functions
7. Global Statements

Overview of Multiple Data Sets

1. Concatenating data set using Set statement
2. Interleaving several datasets
3. Modifying (creating) data set
4. Concatenating data set using PROC APPEND
5. Merging datasets (Match-merging SAS data set, eliminating Non-matches)
6. Updating dataset
7. Outputting multiple observation
8. Writing to multiple SAS datasets
9. PROC EXPORT/IMPORT
10. PROC CONTENTS

Managing Data

1. Conditionally IF-THEN-ELSE execute SAS statements
2. SORT observations in a SAS data set
3. Controlling the output of variables and observations
4. KEEP, DROP, DELETE, RENAME, RETAIN, BY, FILE, PUT and OUTPUT Statements
5. Applying formats and creating user-defined format by PROC FORMAT
6. SAS DO-LOOPS
7. SAS Array

Summarizing DATA

1. Generating summary statistics by numerical functions
2. Creating an accumulating total variable
3. Accumulating totals for a group of data

Generating Reports

1. Generating reports using the PRINT procedure
2. Generating frequency tables using PROC FREQ procedure
3. Generating report using MEANS procedure
4. Generating report using REPORT procedure
5. Enhancing report through the use of labels, SAS format, titles, footnotes and SAS System reporting options
6. Introduction to ODS
7. Generating HTML/PDF output

Debugging Techniques

1. Using the PUT Statement