Address:

CSCAR

The University of Michigan,

3554 Rackham Building

915 E. Washington St.

Ann Arbor, MI 48109-1070

I work at CSCAR, the Center for Statistical Consultation and Research at the University of Michigan. We are located on the third floor of the Rackham Building on the University of Michigan Central Campus, (Rackham is located at J-1, if you click on this link to a map of Central Campus) near the Carillon.

Check out our book!

I am co-author of a book published by Chapman & Hall/CRC Press in November, 2006, Linear Mixed Models: A Practical Guide using Statistical Software with Brady West from CSCAR and Andrzej Galecki from the Institute of Gerontology at the University of Michigan. This book describes how to carry out an analysis of clustered, longitudinal, or repeated measures data sets using linear mixed modeling (LMM) procedures in SAS, SPSS, Stata, R, and HLM. The data sets analyzed in the book were mostly from clients with whom we have consulted at CSCAR, and show how real-world problems can be approached with widely used software. We provide descriptive statistics and basic graphics for each data set, model-building strategies, and step-by-step information on how to analyze each data set with each software procedure, including the appropriate syntax, and a comparison of the models fitted using each procedure. We also provide an overview of the theoretical concepts involved in LMMs. You can check the LMM book web page for data sets and up-to-date syntax for each of the software packages.

My home page has resources for the workshops and courses that I either teach, co-teach or assist in teaching, and some graphics on how to import an Excel Spreadsheet into SAS. There are also some fun pictures at the end of this page.

A web page listing some of my professional qualifications is available, if you Click here.

Intermediate SAS Workshop

The Intermediate SAS Workshop is presented in the fall and winter semesters by CSCAR.

In-class exercises can be found here:

exercise1.doc (One-to-many merging) Click here to view the exercise 1 assignment.

exercise1.sas Click here to view the SAS code for exercise 1.

exercise2.doc (Using arrays in SAS) Click here to view the exercise 2 assignment.

exercise2.sas Click here to view the SAS code for exercise 2.

exercise3.doc (Rearranging data from wide to long) Click here to view the exercise 2 assignment.

exercise3.sas Click here to view the SAS code for exercise 3.

exercise4.doc (Creating counts and summarizing data) Click here to view the exercise 4 assignment.

exercise3.sas Click here to view the SAS code for exercise 4.

exercise5.doc (Creating lagged variables in a SAS dataset) Click here to view the exercise 5 assignment.

exercise5.sas Click here to view the SAS code for exercise 5.

Data sets and command files used for the workshop can be found here:

labdata.7z Click here to download a 7-z archive file containing SAS command files, and input datasets in different formats (.dat, .txt, .csv, .xls, .por) that will be used in the workshop.

sasdata1.7z Click here to download a 7-z archive file containing SAS version 6 datasets (.sd2 extension) and a SAS version 6 formats catalog (formats.sc2) used in the workshop.

sasdata2.7z Click here to download a 7-z archive file containing SAS version 9 data sets (.sas7bdat extension).

Statistical Graphics Using SAS 9.2

This two-hour workshop gives information on how to create simple statistical graphics, including boxplots, barcharts, histograms, scatterplots, loess fits, and scatterplot matrices using SAS 9.2.

Handouts and command files used for the workshop can be found here:

Statistical_Graphics.doc This handout shows examples of how to create some common statistical graphs using SAS 9.2.

sgraphics.sas SAS command file to be used with the handout: Statistical_Graphics.doc.

ODS Graphics Using SAS.doc This handout shows examples of how to use the SAS ODS system to create graphics for some common statistical procedures in SAS 9.2.

ods_graphics.sas SAS command file that shows how to get ods graphics with various statistical procedures in SAS.

Datasets used for the workshop can be found here:

employee.sas7bdat SAS dataset to be used in the SAS graphics workshop.

afifi.sas7bdat SAS dataset to be used in the SAS graphics workshop.

autism.csv comma separated raw data file to be used in the SAS graphics workshop.

skelleftea.sas7bdat SAS dataset to be used in the SAS graphics workshop.

Biostatistics 600

General handouts can be found here:

B600_Day1_2009.doc This is the handout for Day 1 (Sept 2) of Biostat 600 for 2009.

B600_Day2_2009.doc This is the handout for Day 2 (Sept 3) of Biostat 600 for 2009.

Fast_Facts.doc This handout summarizes a lot of basic fast facts for using SAS.

fastfacts.sas This SAS command file goes along with the handout on Fast Facts for SAS.

save_sasgraphs.doc This handout shows how to save a SAS graph from either the SAS/Graph window, or from a Statistical Graphics output, and import it into Word or PowerPoint.

fonts.sas This little SAS command file contains a line of code that will make your SAS output look good when printed from any computer, whether it has SAS loaded on it or not. It changes the SAS font that is normally used to a more generic font. This will get rid of the funky-looking little row, such as fffff for a line in the output for tables, etc. Submit this line of code at the beginning of your SAS session whenever you run SAS.

SAS_Functions.doc This link to a portion of the SAS documentation gives a listing of SAS functions from SAS release 9.2.

Day 1 SAS commands that go along with handouts discussed in class can be found here:

instream.sas Commands for reading instream data (contained in the SAS Program Editor) into SAS.

readdata.sas Commands for reading raw data into SAS.

missing.sas Commands for use when setting up missing value codes.

date.sas Commands for reading in and setting up dates in SAS.

descript.sas SAS commands that demonstrate how to carry out simple descriptive statistics.

Day 2 SAS commands that go along with handouts discussed in class can be found here:

useperm.sas Commands for using a permanent SAS dataset.

saveperm.sas Commands for saving a permanent SAS dataset.

datamgt.sas Commands for managing SAS datasets are included here.

basic_stat.sas SAS commands for basic one-sample and two-sample statistical tests are included here.

sgraphics.sas SAS commands for creating simple plots using Proc Sgplot, Proc Sgpanel and Proc Sgscatter are included here.

Day 3 SAS commands that go along with handouts discussed in class can be found here:

fastfacts.sas basic SAS commands illustrating a number of common tasks using SAS.

Data files used in class examples can be downloaded here:

b600rawdata.zip Zipped archive containing Blank delimited (.dat) files, Comma delimited (.csv) files, Tab delimited (.txt) files, Excel (.xls) files, SPSS portable (.por) files, and SAS portable (.xpt) files. Save this archive on the desktop, and then unzip it to a folder called labdata.

sasdata1.zip SAS version 6 data sets (.sd2 files)

sasdata2.zip SAS version 9 data sets (.sas7bdat) and a SAS version 7 data set (.sd7 file).

Class exercises can be downloaded here:

B600_Exercise1_2009.doc Exercise 1: Reading a data set into SAS, setting up missing value codes, and getting simple descriptive statistics.

brca.dat Raw data file to be used with Exercise 1.

B600_Exercise2_2009.doc Exercise 2: Creating a permanent SAS dataset. Creating new variables in a dataset through recodes, boxplots, simple one-sample and two-sample tests.

Epidemiology 759: Introduction to SAS

I teach a week-long course on Introduction to SAS, Epidemiology 759, in the Graduate Summer Session in Epidemiology, at the University of Michigan School of Public Health.

Zipped and other data files can be downloaded here:

SAScmds.zip Zipped archive containing SAS command files that go along with the examples in the workbook. Download this archive to your desktop and then double-click to extract the files from the archive.

rawdata.zip Raw data (.dat, .txt) files to be used in examples, plus Excel files (.xls, .csv) files.

sasdata1.zip SAS version 6 data sets to be used as examples in the course.

sasdata2.zip SAS version 8/9 data sets (.sas7bdat) to be used in the course.

recode.sas SAS command files to be used for recoding variables and creating dummy variables.

date.sas SAS command files to be used for working with dates in SAS.

survey.dat Raw data file to be used in working with dates in SAS.

afifi.sas7bdat SAS dataset that can be used with the Graphics commands.

autism.csv Raw data file in CSV format that can be used with the Graphics commands.

General handouts can be found here:

Preparing Data Using Excel This web page from CSCAR gives an explanation of how to set up an Excel file for use with a statistical package, such as SAS or SPSS.

fonts.sas This little SAS command file contains a line of code that will make your SAS output look good when printed from any computer (it will get rid of the funky-looking little row, such as fffff for a line in the output for tables, etc.) whether you have SAS installed on that computer or not. Submit this line of code at the beginning of your SAS session whenever you run SAS.

SAS_Functions.doc This document gives a listing of SAS functions from SAS release 8.2.

Exercises can be downloaded here:

Epid759-Exercise_Descriptives.doc This was formerly called Exercise 2. In this exercise, you are asked to read in raw data for the brca dataset, and use different SAS procs to generate descriptive statistics and information about the dataset.

Epid759-Exercise_Recodes.doc Exercise on recoding variables in the brca dataset.

Epid759-Exercise_Data_Management.doc Exercise on data management skills using the brca dataset.

brca.sas7bdat Permanent SAS dataset to use in Exercises.

readbrca.sas SAS commands used to create the brca.sas7bdat permanent SAS dataset.

Epid759-Exercise_Merging.doc Exercise on stacking, merging, and summarizing (aggregating) data.

merge_exercise.sas SAS commands (Answer key) for the exercise on merging datasets.

Meta-Analysis Workshop

The Meta-Analysis Workshop is presented by staff of the University Library and CSCAR.

bcg2.dta Click here to download the Stata datafile which can be used for the in-class examples checking for publication bias and odds ratios across studies.

dmfs.dta Click here to download the Stata datafile which can be used for the in-class examples on combining estimates of means and standard deviations.

bcg.sas Click here to download the SAS commands which can be used to analyze the bcg data example.

Introduction to SAS Proc Mixed: CSCAR Workshop

The Introduction to Proc Mixed (Longitudinal and Clustered Data) Workshop is presented by CSCAR.

Click here to link to a web page where you can download the data sets and SAS commands for the labs for the Proc Mixed Workshop.

Introduction to SAS for Stat Dept

The Introduction to SAS Workshop is being offered by CSCAR at the Statistics Department April 4th, 5th, and 11th. Instructors are Kathy Welch and Heidi Reichert.

Files for the workshop can be found here:

workshop_command_files.zip

workshop_data_files.zip

H06A_H.da H06A_H.da data file from the HRS study.

H06A_H.sas SAS commands to read in the H06A_H.da data file.

H06A_R.da H06A_R.dat data file from the HRS study.

H06A_R.sas SAS commands to read in the H06A_R.da data file.

SAS_Functions.doc This document gives a listing of SAS functions from SAS release 8.2.

macro_random_sample_steps.sas SAS commands illustrating the steps in creating a macro to generate random samples from a dataset.

Biostatistics 510: Statistical Computing Packages

I teach Biostat 510 in the Biostatistics Department at the University of Michigan School of Public Health . We cover simple data management tasks and basic statistical techniques using the statistical software packages, SAS and SPSS.

The Final Project handout and datasets for each student can be found here:

General Handouts can be found here:

syllabus_2009.doc The course syllabus gives information on topics to be covered, homework assignments, and the final project.

Import_Excel.doc This document gives step-by-step instructions on how to set up an Excel file for use with a statistical package and how to import the file into SAS.

save_sasgraphs.doc This document gives instructions on how to save/export graphs created in the SAS/GRAPH window using SAS 9.1 or 9.2 and how to save graphs created using Statistical Graphics Procedures in SAS 9.2. These graphs can be easily imported into a Microsoft Word document or a Power Point presentation.

baseball.sas7bdat This SAS dataset is used for the example on saving SAS/Graph files above. To use this file, single-click on it, and save it to a folder on your desktop (the folder should preferably be called MYLIB).

fonts.sas This little SAS command file contains a line of code that will make your SAS output look good when printed from any computer (it will get rid of the funky-looking little row, such as fffff for a line in the output for tables, etc.) whether you have SAS installed on that computer or not. Submit this line of code at the beginning of your SAS session whenever you run SAS.

SAS_Functions.doc This document gives a listing of SAS functions from SAS release 8.2.

In-Class handouts for 2009 can be found here.

Click here to get In-Class Handouts for 2009.

Homework assignments for 2009 can be found here.

Click here to get to the homework assignments for 2009.

Data sets and commands that accompany the Course Pack can be found here: Documentation for these data sets, including information on the variables, the variable types, and variable codes can be found in Chapter 27, page 174, of the Course Pack.

b510_data.zip Archive containing raw data sets, Excel file, tab-delimited data, comma separated values (.csv) files, and SPSS portable files that may be read into SAS.

b510_sas_commands.zip Archive containing SAS commands that go along with each chapter in the course pack.

sasdata1.zip SAS version 6 data sets (.sd2)

sasdata2.zip SAS version 8/9 data sets (.sas7bdat and .sd7)

Information on Biostat 510 from last year.

Click here for information on Biostat 510 for Winter 2008.

Regression Analysis Workshop

The Regression Analysis Workshop is offered by CSCAR.

Data Sets for lab examples:

cars.sav You can Right-Click here to download the Cars.sav SPSS data set for the lab sessions. Do not open this file from the browser!

regression.zip Click here to download the Zip file containing the SPSS data sets and SPSS portable files for use in the afternoon lab for the regression workshop. Download the file to your desktop and unzip the data sets to a folder called "Regression" (you will have to create the folder) on your desktop.

SAS commands and the dataset for Box-Cox transformations are included below:

boxcox.sas SAS commands to figure out a good transformation for Y, using the Box-Cox method.

cars.por SPSS portable file to use in Box-Cox transformations example.

model_selection.sas SAS commands for model selection methods, including All Possible Regressions, Mallow's CP, and Adjusted R-Square.

fitness.por SPSS portable file to use in example of model selection methods using SAS.

Arbor Research Proc Mixed Workshop (November, 2007)

This workshop uses examples from our new book Linear Mixed Models: A Practical Guide using Statistical Software. The data sets and examples used in the book are included on this web page: Web page for Linear Mixed Models Book where you can also get information on a 20% discount on the book.

Workshop examples and data sets are included in the zipped file below:

procmix.zip this zipped file contains data sets and SAS commands used in examples for the Workshop. Download and unzip this archive to a folder on your desktop called procmix.

ratpup_diagnostics.rtf this rtf file contains SAS ODS output from an analysis of the Rat Pup data using SAS Proc Mixed, along with diagnostic plots and the experimental influence diagnostics available in SAS 9.1.3.

SAS Data Step Workshop for Arbor Research

This workshop covers parts of the CSCAR Intermediate SAS Workshop presented in the fall semester.

labdata.zip this zipped file contains data sets and SAS commands used in examples for the Workshop. Download and unzip this archive to a folder on your desktop called labdata.

sasdata1.zip this zipped file contains SAS version 6 data sets (.sd2 extension), and a SAS version 6 formats catalog (formats.sc2). Download and unzip this archive to a folder on your desktop called sasdata1

sasdata2.zip this zipped file contains SAS version 9 data sets (.sas7bdat and a version 7/8 data set .sd7). Download and unzip this archive to a folder on your desktop called sasdata2

bostfire_setup.sas this SAS command file contains syntax to read in the data for the Boston Arson Study, so it is ready to be merged.

bostfire_merge.sas Do you really want to peek?? This SAS command file contains syntax to read in the data for the Boston Arson Study, and merges it. Check this after you have tried to do the merge yourself!

da9972.bostfire this raw data file contains information about fires in the Boston Metropolitan area.

da9972.macensus this raw data file contains information on characteristics of Census tracts in the greater Boston area. It can be merged with the Boston Fire data.

ratbrain.dat this raw data file contains information on activation of a chemical in two treatments (Basal, and Carbachol) and three regions (BST, LS, and VDB) for five rats in Wide format.

rat_brain_restructure.sas SAS commands to restructure the ratbrain data set from wide to long format.

Financial Engineering: Introduction to SAS

Zipped data files and SAS command files can be downloaded here:

finan_data.zip Zipped archive containing SAS command files, Excel files, SPSS portable files, etc. Unzip the files in this archive to the c:\temp\finan_data folder.

sasdata1.zip SAS version 6 data sets (.sd2). Unzip the files in this archive to the c:\temp\sasdata1 folder.

sasdata2.zip SAS version 8/9 data sets (.sas7bdat) and SAS transport files (.xpt). Unzip the files in this archive to the c:\temp\sasdata2 folder.

General handouts can be found here:

Preparing Data Using Excel This web page from CSCAR gives an explanation of how to set up an Excel file for use with a statistical package, such as SAS.

fonts.sas This little SAS command file contains a line of code that will make your SAS output look good when printed from any computer (it will get rid of the funky-looking little row, such as fffff for a line in the output for tables, etc.) whether you have SAS installed on that computer or not. Submit this line of code at the beginning of your SAS session whenever you run SAS.

SAS_Functions.doc This document gives a listing of SAS functions from SAS release 8.2.

Lecture notes can be found here:

SAS Key Concepts. This handout gives basic information on using SAS in the Windows environment.

Simple Descriptive Statistics using SAS. This handout illustrates SAS commands for carrying out basic descriptive statistics for continuous and categorical variables, and some simple graphs, including histograms, boxplots, and scatter plots with regression lines.

Overview of Data Management Tasks using SAS. This handout gives basic information on using SAS for data management, including tasks such as modifying a data set by adding new variables, recodes of variables, subsetting data, selecting cases for an analysis, etc.

Basic Statistical Tests using SAS. This handout illustrates SAS commands for basic statistical tests, including one-sample and two-sample t-tests, such as chi-square goodness of fit tests, and chi-square tests of independence, and one-sample and independent samples t-tests.

Oneway ANOVA using SAS. This handout gives basic information on using SAS for a oneway analysis of variance.

Paired t-test Using SAS.This handout illustrates how to use SAS for a paired t-test.

Bivariate Correlation and Multiple Regression Analyses for Continuous Variables using SAS. This handout gives basic information on how to carry out linear regression analyses using SAS, including checking the model assumptions with graphical analysis of residuals.

Checking for Multicollinearity Using SAS. This handout illustrates using SAS to detect multicollinearity in a multiple regression analysis.

Regression Models for Binary Outcomes Using SAS. This handout illustrates using SAS for analysis of a binary outcome variable, using a logistic regression model.

Regression Models for Count Outcomes Using SAS. This handout illustrates using SAS for analysis of a dependent variable that is a count, using a Poisson regression model.

Quizzes and Answer keys can be found here, along with the appropriate SAS code for each quiz.

Quiz 1.

Quiz 1 Key.

SAS code for Quiz 1.

Quiz 2.

Quiz 2 key.

SAS codes for Quiz 2.

Quiz 3.

Key for Quiz 3.

SAS commands for Quiz 3.

The Regression for Non-Normally Distributed Data Using SAS Workshop is presented by CSCAR.

Download the SAS commands and the necessary data sets listed below, to the c:\temp\glmwkshp folder. You will need to create this folder before you begin.

Lab Examples 1-5 Tecumseh Study commands: tecumseh_genmod.sas SAS commands for Tecumseh Study.

Lab Examples 1-5 Tecumseh Data: tecumseh.sas7bdat SAS data set for Tecumseh Study.

Lab Examples 1-5 Tecumseh Data in Excel: tecumseh.xls Excel File for Tecumseh Study.

Lab Example 6 Alligator Data commands: alligator.sas SAS commands for a log-linear model, with a categorical outcome (food preference of alligators), being predicted by alligator size, and the lake in which the alligators were located.

Lab Example 7 Ship Data commands: ship.sas SAS commands for the Ship Data (Poisson Regression with an offset).

Lab Example 7 Ship Data Set (Excel File): ship.xlsExcel data set to use for ship example.

Lab Example 8: Epilepsy Data SAS commands (data are included in the command file) epilepsy.sas Data and SAS commands for the Epilepsy study.

Lab Example 9: Tecumseh Study SAS commands to set up longitudinal data for GEE analysis. tecumseh_gee.sas SAS commands to set up the Tecumseh data in longitudinal form for GEE analysis.

Glimmix macro. glimmix.sas SAS commands to define the glimmix macro. Download this command file to your c:\temp\glmwkshp\ folder.

Epidemiology 556:

data.xls Click here to download the practice class data set.

epid556.sas Click here to download SAS commands from Class 1 of Epid 556. These commands show how to get basic descriptive statistics for a data set imported from Excel.

epid556class2.sas Click here to download SAS commands from Class 2 of Epid 556. These commands show how to import an Excel spreadsheet using SAS commands, how to get simple descriptive statistics, bar charts, scatter plots, correlations, and regressions. The calculation of new variables

Class2analysis.docClick here to download the SAS commands from Class 2 of Epid 556, plus the output in a Microsoft Word Document.

Epidemiology 552:

Epid552_Fall2003.doc Instructions for getting data from American Factfinder and Running Commands in SAS.

age_sex.xls Excel file containing Age and Sex Distribution for United Stages, Michigan and a sample County.

setup_age_sex.sas SAS command file to read in the AGE_SEX.xls file and do cross tabs.

hospital.sas SAS command file to read the hospital discharge data set.

How to Import an Excel Worksheet in SAS Release 8 for Windows.

Instructions for importing an Excel 4.0 worksheet called Pulse.xls and saving it as a temporary SAS data set are included in slides shown below. Click on any slide to get an enlarged version.

Slide2.GIF	Slide3.GIF
Slide4.GIF	Slide5.GIF
Slide6.GIF

Go to File...Import.

Choose the File Type as Excel 4.0 Worksheet.

Locate and select the file using the browse button.

Save the data set and finish.

Check the log to be sure the data set was created.

Pictures of our Japan Trip, November, 2007.

Click here to see our Japan Pictures.

Pictures of fishing at the Outer Banks, North Carolina.

Fishing in Currituck Sound.

Landing a nice striped bass.

A nice striped bass.

Pictures of our Manistee River Kayaking Trip are available here.

Starting out beside the Manistee River North of Grayling.

A view of the Manistee River from our cabin.

Kayaks parked for the night at our cabin.

Little flowers by the river behind our cabin.

Not a bad back door view!

The kayaking gang of five.

Pictures of our winter 2007 cross-country skiing weekend at Sleeping Bear in northern Michigan.

View of Lake Michigan from the Pierce Stocking Road on a snowy data at Sleeping Bear.

Another view of Sleeping Bear Dunes and Lake Michigan from the Pierce Stocking Road. Not as snowy on this day!

Skiing on a trail at Sleeping Bear. There were signs warning us about cougars, but I'm sure I could have outskiied them!

Snowy pine trees at Sleeping Bear.

Snowy hardwoods at Sleeping Bear.

Yes, this is the Sleeping Bear dune, and it was cold! Kids were actually sledding down this dune.

OK, so this is actually Jim and me skiing at Radrick Farms outside Ann Arbor.

---

Jim and I went to Tamil Nadu in the South of India in the spring of 1999. Click on the map of India to go to our India Page!

last updated: January 10, 2009