Course Contents

Part 1

1. Introduction to SAS

• Overview of SAS

• Introduction to SAS Environment

• Quiz
  
  

2. Importing Data into SAS: Temporary & Permanent SAS Data

• Reading data delimited by spaces (.txt file) using list input

• Reading data delimited by commas (.csv file) using list input

• Reading data with custom delimiters using list input

• Reading data in fixed columns using column input

• Using formatted input to read dates with SAS informat

• Formatting SAS date values for display

• Creating internal SAS datasets using the DATALINES statement

• Assigning library names and creating permanent datasets using the LIBNAME statement

• Importing Excel files into SAS using PROC IMPORT

• Importing external delimited data files using PROC IMPORT

• Quiz

• Coding Exercise
  
  

3. Data Manipulation in SAS

• Using the SET statement in the DATA step to create SAS datasets

• Overview of SAS functions

• Conditional execution using IF-THEN/ELSE, DO, and END statements

• Defining variable length with the LENGTH statement

• Subsetting data using the IF and DELETE statements

• Quiz

• Coding Exercise 1

• Coding Exercise 2
  
  

4. Creating Labels and Formats

• Adding labels to variables using the LABEL statement and PROC PRINT with the SPLIT option

• Assigning formats to variables using the FORMAT statement

• Creating user-defined formats

• Storing and referencing user-defined formats

• Using PROC FORMAT with the CNTLIN option to define custom formats

• Quiz

• Coding Exercise 1

• Coding Exercise 2
  
  

5. Manipulating Character and Numeric Data

• Converting between character and numeric values using automatic conversion, PUT, and INPUT functions

• Extracting words from character values using the SCAN function

• Extracting and replacing portions of character values using the SUBSTR function

• Concatenating character values using TRIM and CATX functions

• Searching for substrings using the INDEX and FIND functions

• Changing text case using UPCASE, LOWCASE, and PROPCASE functions

• Replacing or removing characters with the TRANWRD function

• Numeric functions: INT and ROUND for modifying numeric values

• Additional numeric functions: SMALLEST, LARGEST, and RAND functions

• Quiz

• Coding Exercise
  
  

6. Working with SAS Date Values

• Understanding SAS date and time storage

• Extracting year, quarter, month, day, and weekday using YEAR, QTR, MONTH, DAY, and WEEKDAY functions

• Retrieving the current date and calculating time intervals using TODAY, DATE, and INTCK functions

• Calculating date differences in days and years using the DATDIF and YRDIF functions

• Quiz

• Coding Exercise
  
  

7. Processing Data Using DO Loops

• Constructing DO loops (Part 1)

• Constructing DO loops (Part 2)

• Using DO UNTIL and DO WHILE for conditional execution

• Combining conditional clauses with iterative DO statements

• Quiz

• Coding Exercise
  
  

8. Simplifying Code with ARRAYS

• Creating one-dimensional arrays

• Defining variables within an ARRAY statement

• Assigning initial values to arrays and creating temporary array elements

• Working with two-dimensional arrays

• Quiz

• Coding Exercise 1

• Coding Exercise 2
  
  

Part 2

9. Combining SAS Datasets

• One-to-one merging

• Concatenating datasets

• Appending datasets

• Interleaving datasets

• Performing match merging

• Understanding types of match-merging: one-to-one and one-to-many

• Renaming variables in match-merging

• Excluding unmatched observations in match-merging

• Selecting specific variables during match-merging

• Quiz

• Coding Exercise
  
  

10. Reshaping SAS Datasets: DATA Step & PROC TRANSPOSE

• Converting one observation per subject into multiple observations using the DATA step

• Converting multiple observations per subject into one observation using the DATA step (First and Last functions)

• Using PROC TRANSPOSE to convert one observation into multiple observations

• Using PROC TRANSPOSE to convert multiple observations into one observation

• Quiz

• Coding Exercise
  
  

11. Statistical Procedures in SAS

• Sorting data using PROC SORT

• Generating reports with PROC PRINT (VAR, SUM, WHERE, ID, BY statements)

• Summary statistics and multilevel summaries using PROC MEANS

• Creating one-way and two-way frequency tables with PROC FREQ

• Enhancing frequency tables with options (NLEVEL, ORDER, LIST, CROSSLIST)

• Descriptive statistics using PROC UNIVARIATE

• Viewing dataset contents using PROC CONTENTS

• Exporting data to standard formats (CSV, Excel) using PROC EXPORT

• Quiz

• Coding Exercise
  
  

12. Generating Reports with ODS Statements

• Overview of ODS with examples (PDF, RTF, PowerPoint output)

• Creating HTML output with ODS options

• Exporting data to Excel with multiple worksheets using ODS

• Quiz

• Coding Exercise
  
  

13. Error Handling in SAS

• Identifying syntax errors (misspelled keywords, missing/mismatched elements, invalid options)

• Debugging logical errors using PUTLOG, ERROR statements, and temporary variables (N, ERROR)

• Quiz

• Coding Exercise
  
  

14. SAS Macros: Essentials

• Introduction to SAS Macros

• Using macro variables to replace text strings

• Generating SAS code using macros

• Passing information to macros using parameters

• Quiz

• Coding Exercise
  
  

15. PROC SQL: Essentials

• Retrieving data from a single table using the SELECT statement

• Performing INNER JOIN to retrieve data from multiple tables

• Performing OUTER JOIN to retrieve data from multiple tables

• Quiz

• Coding Exercise
  
  

16. Hands-on Project: Case Study on Weight Loss Data

• Step-by-step project instructions and Excel data file

• Project solution (video tutorial)

• Downloadable SAS code