Instructor

Syllabus

Office Hours -- Spring 2023

Class Meeting Time

Purpose: To help students learn advanced SAS computing programming skills, including SQL queries; data management, modification and formatting; and SAS macro programming. To help students learn efficient methods of SAS programming.

Current Textbook: SAS Certified Professional Prep Guide: Advanced Programming Using SAS 9.4 (First edition), by SAS Institute. ISBN: 9781642954678. Publication Date: October 2019

Access Instructions for SAS

• SAS OnDemand Entry Page

• SAS OnDemand Control Center

SAS Resources

• SAS Resources (PowerPoint)

• SAS Certification Information

• A neat picture of various types of SQL joins (Courtesy of Caroliegh)

Slides for Class Notes

• Basic PROC SQL Queries (Chapters 1 & 2) Slides (PowerPoint)

• More Advanced PROC SQL Queries and Subqueries (Chapters 1, 2 & 5) Slides (PowerPoint)

• Correlated Subqueries (Chapter 5) Slides

• Creating and Managing Tables Using PROC SQL (Chapter 2) Slides (PowerPoint)

• Joining Tables Horizontally Using PROC SQL (Chapter 3) Slides (PowerPoint)

• Chapter 3 Supplementary Slides

• Joining Tables Vertically Using Set Operators (Chapter 4) Slides (PowerPoint) or (pdf)

• Creating and Managing Views (Chapter 5) Slides (PowerPoint) or (pdf)

• Creating and Using Macro Variables and Macro Functions (Chapters 7 & 8) Slides (PowerPoint) or (pdf)

• Creating Macro Variables during DATA step or PROC SQL Execution (Chapter 8) Slides (PowerPoint) or (pdf)

• Creating and Using Macro Programs (Chapter 9) Slides (PowerPoint) or (pdf)

• Using Macros for Collation (post-Chapter 9) Slides (PowerPoint) or (pdf)

• Advanced Macro Techniques (Chapter 10) Slides (PowerPoint) or (pdf)

• Data Visualization Slides (PowerPoint) or (pdf)

• Combining Data Vertically Slides (PowerPoint) or (pdf)

• Combining Data Horizontally Slides (PowerPoint) or (pdf)

• Arrays, PROC TRANSPOSE, and Hash Objects (Chapters 11 & 12) Slides (PowerPoint) or (pdf)

• Review of PROC FORMAT Slides (PowerPoint) or (pdf)

• Creating Picture Formats (Chapter 13) Slides (PowerPoint) or (pdf)

• Alternatives to IF/THEN/ELSE Supplement Slides (PowerPoint) or (pdf)

• Creating Functions and Subroutines (Chapter 13) Slides (PowerPoint) or (pdf)

• Advanced Character Functions (Chapter 14) Slides (PowerPoint) or (pdf)

• Creating Samples in SAS Slides (PowerPoint) or (pdf)

• Controlling Data Storage Space Slides (PowerPoint) or (pdf)

• Using Best Practices Slides (PowerPoint) or (pdf)

• Efficient Sorting Slides (PowerPoint) or (pdf)

• Efficient Querying Slides (PowerPoint) or (pdf)

• Modifying SAS Data Sets and Tracking Changes Slides (PowerPoint) or (pdf)

SAS Code: Examples from Class

• Example code: Basic PROC SQL Queries (Chapters 1 & 2)

• Example code: More Advanced PROC SQL Queries and Subqueries (Chapters 1, 2 & 5)

• Example code: Extra Examples of PROC SQL Queries (Chapters 1 and 2)

• Example code: Correlated Subqueries (Chapter 5)

• Example code: Creating and Managing Tables Using PROC SQL (Chapter 2)

• Example code: Joining Tables Horizontally Using PROC SQL (Chapter 3)

• Chapter 3 Supplementary Example code

• Example code: Joining Tables Vertically Using Set Operators (Chapter 4)

• Chapters 3 and 4 Extra Examples

• Supplementary Example code with CASE statement and compressing

• Example code: Creating and Managing Views (Chapter 5)

• Example code: Creating and Using Macro Variables and Macro Functions (Chapters 7 & 8)

• Example code: Creating Macro Variables during DATA step or PROC SQL Execution (Chapter 8)

• Example code: Creating and Using Macro Programs (Chapter 9)

• Example code: Using Macros for Collation (post-Chapter 9)

• School data set for Macro Collation examples (.txt file)

• Example code: Data-driven Macro Calls and the DOSUBL function (Chapter 10)

• Example code: Very Basic SAS graphs (not part of book)

• Cranford's Data Visualization article

• Robert Allison's SAS Graphics and Data Visualization website

• Example code: Combining Data Vertically (not part of book)

• Fall8.txt, Fall9.txt, Fall10.txt

• Fall 2008.xls, Fall 2009.xls, Fall 2010.xls

• Example code: Combining Data Horizontally (not part of book)

• Example code: Arrays and PROC TRANSPOSE (Chapter 11)

• Example code: Hash Objects (Chapter 12)

• Example code: Creating Picture Formats (and other formats) with PROC FORMAT (Chapter 13)

• Example code: Creating Functions and Subroutines (Chapter 13)

• Example code: Advanced Character Functions (Chapter 14)

• Example code: PERL expressions (Chapter 14, second part)

• Example code: Creating Samples in SAS (not part of book)

• Details about Sampling without Replacement algorithm Example

• Example code: Controlling Data Storage Space (not in book)

• ACTfemale.txt, ACTmale.txt

• Example code: Using Best Practices (not in book)

• Example code: Efficient Sorting and Querying (not in book)

• Chapter 18 Example code: Modifying SAS Data Sets and Tracking Changes (not part of book)

• Example code: Creating and Managing Indexes (not in book)

• Simulated Medicare data base for examples with Indexes (csv file)

• Example code: Managing Processing Using PROC SQL (not in book)

• Example code Related to Storing Macros (Chapter 10) --- not useful for SAS Studio work

• Example code: Efficient SAS Programming and Memory Usage (not in book)

Homework

Instructions for ensuring your HW file is plain text

An Example of a SAS Program with good comments

• STAT 541 Homework 1, Spring 2023 (due Wednesday, Feb. 1 by 11:59 p.m.)

• STAT 541 Homework 2, Spring 2023 (due Wednesday, Feb. 8 by 11:59 p.m.)

• STAT 541 Homework 3, Spring 2023 (due Friday, March 3 by 11:59 p.m.)

• STAT 541 Homework 4, Spring 2023 (due Tuesday, March 21 by 11:59 p.m.)

• STAT 541 Homework 5, Spring 2023 (due Tuesday, April 11 by 11:59 p.m.)

• STAT 541 Homework 6, Spring 2023 (due Thursday, April 20 by 11:59 p.m.)

• STAT 541 Homework 7, Spring 2023 (due Monday, April 24 by 11:59 p.m.)

Data Files for Homework

• Average SAT scores by State

• Tennis League Lists

• Alternative approach to reading in the Tennis League Lists if the above does not work for you

• tennissinglesmore.txt

Example Homework Solutions

• STAT 541 Homework 1 Example Solutions, Spring 2023

• STAT 541 Homework 2 Example Solutions, Spring 2023

• STAT 541 Homework 3 Example Solutions, Spring 2023

• STAT 541 Homework 4 Example Solutions, Spring 2023

• STAT 541 Homework 5 Example Solutions, Spring 2023

• STAT 541 Homework 6 Example Solutions, Spring 2023

• STAT 541 Homework 7 Example Solutions, Spring 2023

Information about the Graduate Student Project

Exams

• Wednesday, Feb. 15: Exam 1

• Wednesday, March 29: Exam 2

• Wednesday, April 26, 9:00 a.m.: final exam