STAT 541 - Spring 2020

Welcome to STAT 541, Advanced SAS Programming. This page contains updates to the course syllabus, computer notes from class, homework assignments and other class materials. Send any questions to grego@stat.sc.edu

• Syllabus

• Course Links
  • SAS certification

  • SASHELP datasets

• Uploading assignments in Blackboard

• Exercises
  • Class Exercise 1

  • Class Exercise 2

  • Class Exercise 3

  • Class Exercise 4

  • Class Exercise 5

  • Class Exercise 6

  • Class Exercise 7

  • Class Exercise 8

  • Class Exercise 9

  • Class Exercise 10

  • Class Exercise 11

  • Class Exercise 12

  • Class Exercise 13

• Slides/Notes
  • Chapter 1 slides Queries in SQL

  • Chapter 2 slides Advanced Queries in SQL

  • Chapter 3 slides Horizontal Tables in SQL

  • Chapter 4 slides Vertical Tables in SQL

  • Chapter 5 slides Creating and Managing Tables in SQL

  • Chapter 6 slides Indexes in SQL

  • Chapter 7 slides Views in SQL

  • Chapter 3 supplementary slides (Self-Join)

  • Chapter 8 slides Processing in SQL

  • Chapter 2 supplementary slides (Correlated Subquery)

  • SAS Resources slides

  • Chapter 9 slides Macro Variables

  • Chapter 10 slides Macro Variables at Execution Time

  • Chapter 11 slides Macro Programs

  • Chapter 11/12 transition slides

  • Chapter 12 slides Storing Macro Programs

  • Chapter 13 slides Sampling

  • Chapter 14 slides Combining Data Sets Vertically

  • Chapter 15 slides Combining Data Sets Horizontally

  • Chapter 16 slides Using Lookup Tables to Match Data

  • Chapter 17 slides Formatting Data

  • Chapter 17 Review slides Review of Formatting Data

  • Chapter 17 Supplement slides Alternatives to IF/THEN/ELSE Processing

  • Chapter 18 slides Modifying SAS Data Sets and Tracking Changes

  • Chapter 19 and Chapter 20 slides Intro to Efficient Programming and Controlling Memory Usage

  • Chapter 21 slides Controlling Data Storage Space

  • Chapter 22 slides Using Best Practices

  • Chapter 23 Supplement (Former Chapter 23) slides Selecting Efficient Sorting Strategies

  • Chapter 23 (Former Chapter 24) slides Querying Data Efficiently

• SAS code and notes
  • SAS documentation

  • Text instructions on loading SAS training data sets.

  • SAS PROC IMPORT code in case Import Wizard fails.

  • Data sets
    • Excel worksheet for sample of Fall 2008 cohort

    • Excel worksheet for 2009 follow-up to sample of Fall 2008 cohort

    • Excel worksheet for 2010 follow-up to sample of Fall 2008 cohort

    • Excel worksheet for bacterial water quality data

    • Tab-delimited text file for simulated Medicare data

    • Comma-delimited text file for SCDOT 2012 traffic count data

  • Code
    • Chapter 1 code Queries in SQL

    • Chapter 2 code Advanced Queries in SQL

    • Chapters 1 and 2 code Additional examples

    • Chapter 3 code Horizontal Tables in SQL

    • Chapter 4 code Vertical Tables in SQL

    • Chapters 3 and 4 code Additional examples

    • Chapter 5 code Creating and Managing Tables in SQL

    • Chapters 4 and 5 supplementary code Joins and CASE

    • Chapter 6 code Indexes in SQL

    • Chapter 7 code Views in SQL

    • Chapter 3 supplementary code

    • Chapter 8 code Processing in SQL

    • Chapter 2 supplementary code

    • Chapter 9 code Macro Variables

    • Chapter 10 code Macro Variables at Execution Time

    • Chapter 11 code Macro Programs

    • Chapter 11/12 transition code

    • Chapter 12 code Storing Macro Programs

    • Chapter 13 code Sampling

    • Chapter 14 code Combining Data Sets Vertically with Fall 08 , Fall 09 , and Fall 10 text files.

    • Chapter 15 code Combining Data Sets Horizontally.

    • Chapter 16 code Using Lookup Tables to Match Data

    • Chapter 17 code Formatting Data

    • Chapter 18 code Modifying SAS Data Sets and Tracking Changes

    • Chapter 19 and Chapter 20 code Intro to Efficient Programming and Controlling Memory Usage

    • Chapter 21 code Controlling Data Storage Space

    • Chapter 22 code Using Best Practices

    • Chapter 23 and Chapter 23 Supplement code Selecting Efficient Sorting Strategies and Querying Data Efficiently

• Test 1
  • Test 1 2012

  • Test 1 2014

  • Test 1 2015

  • Test 1 2017

  • Test 1 2020

• Test 2
  • Test 2 2012

  • Test 2 2014

  • Test 2 2015

  • Test 2 2017

  • Test 2 2020

• Final Exam
  • Final Exam 2012 , Excel worksheet , April 2009 data set , May 2009 data set , and June 2009 data set .

  • Final Exam 2014 , Fairfield traffic data , Kershaw traffic data set , Lancaster data set , and York traffic data set , Fairfield traffic text file , Kershaw traffic text file , Lancaster traffic text file, and York traffic text file .

  • Final Exam 2015

  • Final Exam 2017 and Air Quality text file

  • Final Exam 2020

• Project information
  • Project Guide

Return to Department of Statistics Home Page