Live SAS Base Programming for Analytics and Reporting

Course Modules Breakdown

Live Module 1: Introduction to SAS Ecosystem

• Overview of SAS System: History, Applications
• SAS vs R vs Python: Where SAS shines
• Navigating SAS Interface (SAS Studio, Enterprise Guide)
• Writing your first SAS program

Live Module 2: Accessing and Creating Data

• Reading data from external files: Excel, CSV, TXT
• Using INPUT, INFILE, and DATALINES
• Creating SAS datasets manually
• Assigning libraries and paths

Live Module 3: Data Manipulation and Cleaning

• Sorting and filtering datasets (PROC SORT, WHERE, IF)
• Creating new variables (DATA step logic)
• Handling missing values
• Merging datasets (SET, MERGE, BY statements)

Live Module 4: Data Analysis and Reporting

• Descriptive statistics with PROC MEANS, PROC FREQ, PROC UNIVARIATE
• Generating reports with PROC PRINT and PROC REPORT
• Conditional logic using IF, ELSE IF, and loops
• Formatting output (FORMAT, LABEL, titles and footnotes)

Live Module 5: Advanced Procedures & Functions

• Working with dates and times (INTNX, TODAY, DATEPART)
• Character and numeric functions (SUBSTR, SCAN, ROUND)
• Data summarization using PROC SQL (introduction)
• Exporting datasets and reports to Excel or PDF

Live Module 6: Capstone Project & Evaluation

• Project: Analyze a clinical or HR dataset and generate reports
• Final quiz: Syntax, logic, and debugging scenarios
• Submit .sas files, generated outputs, and documentation for certification