SAS (Statistical Analysis System)

SAS (Statistical Analysis System)

This is a beginner-intermediate level 2-day SAS course. This course requires programming and follow along as most of the training methodologies shall include practical hands-on along with theory.

Learning outcome

By the end of this course the learner may expect to have adequate skills pertaining to:

• Ability to code in SAS
• Ability to integrate data to and from SAS
• Data Preparation
• Data Structuring
• Data Visualization
• Optimization of code
• Data Analysis
• Reporting

Prerequisites

Hardware:

1. Personal computer.
2. Dual Screen.
3. Webcam and microphone.
4. Minimum 5mbps connection.

Software:

1. Windows / MacOS / Linux with GUI.
2. Web browser with access to google and sas.
3. SAS On-Demand Studio.
4. SSH Enabled Terminal.
5. Zoom

Skills:

1. Ability to use the internet.
2. Clear understanding of the file structure in the operating system that the pupil shall use.
3. Basic statistical knowledge.
4. Understanding of what data is.
5. Ability to follow along and an open mind.

Course Outline

1. Introduction
   1. Ice breaker
   2. Set-up
   3. Review
   4. Exploration
   5. Familiarization
2. Munging and Wrangling
   1. SAS Dataset, Variables and Observations
   2. SAS Program Syntax
   3. SAS Data Step and Proc Step
   4. Referencing data in SAS
   5. Data acquisition
   6. Files
   7. Conditions
   8. Functions
   9. Formats
   10. Program Data Vector (PDV)
   11. Loops
   12. Assessment
3. Data Structuring
   1. Stacking
   2. Sorting
   3. Merging
   4. SQL
   5. Filtering
   6. Cleaning
   7. Transposing
   8. Assessment
4. Visualization
   1. Charts
   2. Bars
   3. Plots
   4. Summary Outputs
   5. Other techniques of visualization
5. Code Improvements
   1. Optimizing Code
   2. Macro Variables
   3. Nested macro variables
   4. SAS Macros
   5. Macro Functions
   6. Assessment
6. Practice
7. Assessment