University of Minnesota

School of Public Health

PUBH 6420 - Introduction to SAS Programming: Fall 2017

Instructor: Greg Granditse-mail message
Teaching Assistant: Michael Petzolde-mail message
Office Hours (Mayo C381) M:10:10AM-11:00AM (GG)
 M: 12:20PM-1:10PM (MK)
 We: 11:15AM-12:05PM (MK)
 Fr: 11:15AM-12:05PM (MK)

Help/Information:

  • Syllabus/Class Schedule
  • TOMHS Data Collection Forms
  • TOMHS Data Dictionary
  • TOMHS Data Description (pdf)
  • TOMHS Data Description (text)
  • Working with TOMHS Dataset
  • SAS Online Help
  • Intro to PC SAS
  • Tips on Debugging Programs

    SAS Tip Sheets

  • Working with SAS Code
  • Creating SAS Data Sets
  • Working with SAS Libraries and SAS Data Sets
  • Creating SAS Data Sets from Microsoft Excel Worksheets
  • Creating SAS Data Sets from Delimited Raw Data Files
  • Validating and Cleaning Data
  • Manipulating Data
  • Combining SAS Data Sets Vertically
  • Enhancing Reports
  • Combining SAS Data Sets Horizontally
  • Using ODS to Creat External FIles
  • Controlling Input and Output
  • Summarizing Data
  • Reading Raw Data
  • Manipulating Raw Data
  • Restructuring a Data Set - Proc Transpose
  • Merging SAS Datasets

    Data Sets:

  • students.csv
  • bp.txt
  • tomhs.dat
  • tomhs SAS Dataset
  • cvd.dat
  • hosp.csv
  • president_election_2016.csv
  • endpoint.csv
  • bp.csv
  • All Datasets (.zip)
  • president_election_2012 SAS dataset

    Lectures:

  • Lesson 1 (Sep 11)
  • Lesson 2 (Sep 18)
  • Lesson 3 (Sep 25)
  • Lesson 4 (Oct 2)
  • Lesson 5 (Oct 9)
  • Lesson 6 (Oct 16)
  • Lesson 7 (Oct 23)
  • Lesson 8 (Nov 6)
  • Lesson 9 (Nov 13)
  • Lesson 10 (Nov 20)
  • Lesson 11 (Nov 27)
  • Lesson 12 (Dec 3)
  • Lesson 13 (Dec 10)

    SAS Programs

  • program01 program02 program03 program04 program05 program06 program07 program08 program09 program10
  • program11 program12 program13 program14 program15 program16 program17 program18 program19 program20
  • program21 program22 program23 program24 program25 2012 Election Map program

    Assignments:

    Assignment Solutions


    Final Exam Materials