Maziworld
Base SAS Certification
Back to Dashboard

Course sections

Section 1
Chapter 1: Introduction
1
An overview foundation of SAS
Section 2
Chapter 2: Getting started with SAS
1
Introduction to SAS programs
2
Submitting a program
3
Exercises /quiz
Section 3
Chapter 3: Working with SAS Syntax
1
Mastering Fundamental Concepts
2
Diagnosis and Correcting syntax errors
3
Exercises
Section 4
Chapter 4: Getting familiar with SAS Datasets
1
Understanding the PDV Process
2
Accessing sas data libraries and Relational databases
3
Exercises
Section 5
Chapter 5: Reading SAS Datasets
1
Introduction to Reading Data
2
Using SAS Data as Input
3
Subsetting Observations variables
4
Adding permanent attributes
5
Exercises
Section 6
Chapter 6: Reading excel worksheets
1
Using excel data as input
2
Reading excel worksheets
3
Exercises
Section 7
Chapter 7: Reading delimited raw data files
1
Using standard delimited data as input
2
Using NON standard delimited data as input
3
Exercises
Section 8
Chapter 8: Validating and Cleaning data
1
Introduction to Validating and Cleaning data
2
Examining data errors when reading raw datafiles
3
Validating data with print and freq procedure
4
Validation data with means and Univariate procedure
5
Cleaning invalid data with windows and UNIX
6
Using FSEDIT window to clean the data
7
Exercises
Section 9
Chapter 9:Manipulating the data
1
Creating variables
2
Creating Varibles conditionally
3
Subsetting observations
4
Excersises
Section 10
Chapter 10: Combining the sas datasets
1
Introduction to Combining the datasets
2
Appending the sas datasets
3
Concatenation of sas datasets
4
Merging the sas datasets [One to one / One to many ]
5
Merging datasets with Non-Matches
6
Exercises
Section 11
Chapter 11: Enhancing the Reports
1
Using global statements
2
Adding labels and formats
3
Creating used defined formats
4
Subetting and Grouping Observations
5
Direct output to the external files HTML /PDF/EXCELXP/RTF
6
Exercises
Section 12
Chapter 12: Producing summary reports
1
Using Freq Procedure
2
Using means procedure
3
Using Tabulate Procedure
Section 13
Chapter 13 : Controlling input and output
1
Output multiple observations
2
Writing to multiple sas datasets
3
Selecting variables and Observations
4
Writing to an external file
5
Exercises
Section 14
Chapter 14 : Summarizing Data
1
Creating and Accumulating total variables
2
Accumulating totals for a group of data
3
Exercises
Section 15
Chapter 15 : Reading and writing different types of data
1
Reading Delimited rawdata files
2
Controlling when a record loads
3
Reading hierarchical rawdata files
4
Exercises
Section 16
Chapter 16: Transformations
1
Introduction
2
Manipulating character values
3
Manipulating Numeric Values
4
Manipulating Numeric values based on Dates
5
Converting variable type
6
Exercises
Section 17
Chapter 17 : Debugging Techniques
1
Using PUT Statement
2
Debug Option
Section 18
Chapter 18 : Processing data iteratively
1
DO Loop Processing
2
SAS Array Processing
3
Using SAS Arrays
4
Exercises
Section 19
Chapter 19: Combining the sas datasets
1
Match merging two or more sas datasets
2
Simple joins using sas sql procedure
3
Exercises

Chapter 1: Introduction

An overview foundation of SAS