About the course
  • About the course
  • Course Breakdown
  • First assignment!
SAS tools
  • Chapter Introduction
  • SAS University Edition - download and install
  • Using SAS University Edition
  • Using Jupyter Notebook
  • WPS workbench - download and install
  • Using WPS workbench
  • Chapter summary
Building Blocks
  • Chapter Introduction
  • SAS Programs, Datasets and variables
  • Datasteps and PROC steps
  • SAS Libraries, Permanent and Temporary datasets
  • Assigning libraries in SAS University Edition
  • Chapter summary
Importing data in SAS environment
  • Chapter Introduction
  • Why Import?
  • Importing Data in SAS environment 1
  • How to import data in SAS University Edition?
  • Import Data 1
  • Importing Data in SAS environment 2
  • Importing Data in SAS environment 3
  • Import Data 2 and 3
  • Quiz 1
  • Data Files and Codes
  • Chapter summary
Modifying datasets, Functions, Conditional Processing and SAS Procedures
  • SET statement and SAS Functions
  • Working with Dates in SAS
  • Conditional Processing using IF/THEN/ELSE
  • Data Manipulation
  • About SAS Procedures, PROC SORT
  • PROC PRINT and PROC FREQ
  • Quiz 2
  • PROC MEANS
  • Quiz 3
  • Data Files and Codes
Merging and Exporting datasets
  • Stacking and Interleaving datasets
  • DATA and SET statement options
  • Quiz 4
  • Merging datasets using MERGE statement
  • Exporting Data
  • Quiz 5
  • Case Study 1
  • Data Files and Codes
Loops and Arrays
  • Introduction to Loops and DO Loop
  • Nested DO Loop
  • DO UNTIL and DO WHILE
  • Conditional DO Loops
  • Array Introduction and One Dimensional Arrays
  • Array Bounds
  • Two Dimensional Arrays
  • Data Files and Codes
SQL Procedure
  • Introduction to PROC SQL
  • SELECT statement and its components
  • WHERE clause - conditional processing
  • GROUP BY, ORDER BY and HAVING clause
  • Datasets and Codes 1 - PROC SQL
  • Quiz 6
  • SQL JOINS 1
  • SQL JOINS 2
  • Datasets and Codes 2 - PROC SQL
  • Quiz 7
  • Case Study 1 - PROC SQL
SAS Macros
  • Introduction to SAS Macros
  • Macro Variables 1
  • Macro Variables 2
  • Macro Variables 3
  • Datasets and Codes 1 - SAS Macros
  • Macro Programs 1
  • Macro Programs 2
  • Datasets and Codes 2 - SAS Macros
  • Quiz 8
  • Case Study 1 - SAS Macros
Bonus
  • Bonus