SAS Training and Certification Course Syllabus

Overview: This SAS Training and Certification Course is a comprehensive, project-driven program designed for beginners, offering hands-on experience in data processing, statistical analysis, and automation using SAS. The course spans approximately 21 hours of structured learning, divided into eight modules that progress from foundational concepts to advanced analytics and reporting. You'll gain practical skills in data manipulation, statistical modeling, PROC SQL, macro programming, and end-to-end analytics through real-world projects. With lifetime access and a certificate of completion, this course prepares you for roles in data analysis, statistical programming, and business intelligence.

Module 1: Getting Started with SAS

Estimated time: 2 hours

• SAS University Edition setup
• SAS GUI overview
• Data vs. Proc steps
• Program Data Vector (PDV) basics

Module 2: Processing & Integrating Data Steps

Estimated time: 3 hours

• INFILE and PROC IMPORT for external data
• KEEP, DROP, RENAME, and LABEL statements
• SET and MERGE statements for combining datasets
• Creating permanent SAS datasets

Module 3: Customizing Datasets with Loops & Arrays

Estimated time: 2 hours

• DO loops (DO, DO WHILE, DO UNTIL)
• Array processing for variable recoding
• SAS built-in functions: PUT/INPUT, date/time, numeric, and character functions

Module 4: Advanced SAS Procedures

Estimated time: 3 hours

• PROC SORT and FORMAT for data organization
• PROC MEANS, SUMMARY, and UNIVARIATE for descriptive statistics
• PROC FREQ and TABLES for frequency analysis
• PROC RANK, CORR, and SURVEYSELECT for data transformation and sampling

Module 5: Advanced Statistical Proficiency

Estimated time: 3 hours

• Clustering methods and PROC CLUSTER
• Linear regression with PROC REG
• General Linear Model using PROC GLM
• Logistic regression and survival analysis with PROC LOGISTIC and PROC LIFETEST

Module 6: PROC SQL & Reporting

Estimated time: 2 hours

• PROC SQL syntax and pass-through queries
• Joins, subqueries, and summary queries
• PROC REPORT for tabular output
• Output Delivery System (ODS) for PDF and custom reports

Module 7: SAS Macros & Automation

Estimated time: 2 hours

• Macro variables and macro definitions
• Conditional macros and looping in macros
• Parameterizing programs for dynamic code execution

Module 8: Capstone Project – End-to-End Analytics

Estimated time: 4 hours

• Data ingestion and cleaning workflow
• Statistical analysis and modeling using advanced procedures
• Reporting with PROC REPORT and visualizations

Prerequisites

• Basic understanding of programming concepts
• Familiarity with statistics or data analysis fundamentals
• Access to a computer capable of running SAS University Edition or local SAS installation

What You'll Be Able to Do After

• Install and navigate the SAS environment confidently
• Import, clean, merge, and transform datasets using Data Step and PROC steps
• Apply advanced statistical procedures for modeling and inference
• Write efficient, reusable code using PROC SQL and SAS macros
• Deliver comprehensive analytics reports from raw data to final presentation