Instructor

Syllabus

Office Hours -- Spring 2016

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 Certification Prep Guide: Advanced Programming for SAS 9 (3rd edition), by SAS Institute.

Access Instructions for SAS

• SAS OnDemand Entry Page

• SAS OnDemand Control Center

SAS Resources

• SAS Resources (PowerPoint)

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

Slides for Class Notes

• Chapter 1 Slides (PowerPoint) or Chapter 1 Slides (pdf)

• Chapter 2 Slides (PowerPoint) or Chapter 2 Slides (pdf)

• Chapter 2 Supplementary Slides

• Chapter 3 Slides (PowerPoint)

• Chapter 3 Supplementary Slides

• Chapter 4 Slides (PowerPoint)

• Chapter 5 Slides (PowerPoint)

• Chapter 6 Slides (PowerPoint)

• Chapter 7 Slides (PowerPoint)

• Chapter 8 Slides (PowerPoint)

• Chapter 9 Slides (PowerPoint)

• Chapter 10 Slides (PowerPoint)

• Chapter 11 Slides (PowerPoint)

• Chapter 11-12 bridge Slides (PowerPoint)

• Chapter 12 Slides (PowerPoint)

• Chapter 13 Slides (PowerPoint)

• Chapter 14 Slides (PowerPoint)

• Chapter 15 Slides (PowerPoint)

• Chapter 16 Slides (PowerPoint)

• Chapter 17 Slides (PowerPoint)

• Chapter 17 Review Slides (PowerPoint)

• Chapter 17 Supplement Slides (PowerPoint)

• Chapter 18 Slides (PowerPoint)

• Chapters 19-20 Slides (PowerPoint)

• Chapter 21 Slides (PowerPoint)

• Chapter 22 Slides (PowerPoint)

• Chapter 23 Slides (PowerPoint)

• Chapter 24 Slides (PowerPoint)

SAS Code: Examples from Class

• Chapter 1 Example code

• Chapter 2 Example code

• Chapters 1 and 2 Extra Examples

• Chapter 2 Supplementary Example code

• Chapter 3 Example code

• Chapter 3 Supplementary Example code

• Chapter 4 Example code

• Chapters 3 and 4 Extra Examples

• Chapter 5 Example code

• Supplementary Example code with CASE statement and compressing

• Chapter 6 Example code

• Simulated Medicare data base for Chapter 6 examples (csv file)

• Chapter 7 Example code

• Chapter 8 Example code

• Chapter 9 Example code

• Chapter 10 Example code

• Chapter 11 Example code

• Chapter 11-12 bridge Example code

• School data set for Chapter 11-12 bridge examples (.txt file)

• Chapter 12 Example code

• Chapter 13 Example code

• Details about Sampling without Replacement algorithm Example in Chapter 13

• Chapter 14 Example code

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

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

• Chapter 15 Example code

• Chapter 16 Example code

• Chapter 17 Example code

• Chapter 18 Example code

• Chapters 19-20 Example code

• Chapter 21 Example code

• ACTfemale.txt, ACTmale.txt

• Chapter 22 Example code

• Chapters 23-24 Example code

Homework

• STAT 541 Homework 1, Spring 2016 (due Thursday, Jan. 28 by 4:00 p.m.)

• STAT 541 Homework 2, Spring 2016 (due Wednesday, Feb. 10 by 4:00 p.m.)

• STAT 541 Homework 3, Spring 2016 (due Friday, March 4 by 4:00 p.m.)

• STAT 541 Homework 4, Spring 2016 (due Tuesday, March 29 by 4:00 p.m.)

• STAT 541 Homework 5, Spring 2016 (due Wednesday, April 20 by 4:00 p.m.)

• STAT 541 Homework 6, Spring 2016 (due Monday, April 25 by 4:00 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 2016

• STAT 541 Homework 2 Example Solutions, Spring 2016

• STAT 541 Homework 3 Example Solutions, Spring 2016

• STAT 541 Homework 4 Example Solutions, Spring 2016

• STAT 541 Homework 5 Example Solutions, Spring 2016

• STAT 541 Homework 6 Example Solutions, Spring 2016

Information about the Graduate Student Project

Exams

• Midterm Exam 1: February 17

• Midterm Exam 2: April 6

• Final Exam: Friday, April 29 - 12:30 p.m.