**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 2007, 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.**

Phone: |
(734) 764-7828 |

Fax: |
(734) 647-2440 |

email: |
kwelch@umich.edu |

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 files for use with the workshop can be downloaded here:labdata.zipZipped archive containing SAS command files and raw data files that go with the Workbook. Download this archive to your desktop and then double-click to extract the files from the archive to a folder called "labdata" on your desktop.sasdata2.zipSAS version 9 data sets (.sas7bdat) to be used as examples in the course.

General handouts can be found here:fonts.sasThis tiny 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.docThis link to a portion of the SAS documentation gives a listing of SAS functions from SAS release 9.2.

Command files generated in class that you may want to use can be downloaded here:import_data.sasThis command file gives SAS commands to import a Stata file, an SPSS data set, and an Excel file. Remember, you can use the Import Wizard for both Stata and SPSS data sets, but you need to submit the commands to import an Excel file.saveperm_revised.sasuseperm_revised.sasSteps_when_starting_sas.docxBasics of getting started with SAS.

Exercises using SAS can be downloaded here:Workshop Exercise 1.docxWorkshop Exercise 2.docxWorkshop Exercise 3.docxWorkshop Exercise 4.docxWorkshop Exercise 5.docxWorkshop Exercise 6.docx

Exercises solutions can be downloaded here:Exercise1_key.sasexercise1_revised_key.sasExercise2_key.sasExercise3_key.sasExercise4_key.sasExercise5_key.sasExercise6_key.sas

Biostatistics 600

In class handouts and the SAS commands that go with them can be found here:Brief_tour_of_SAS_Biostat600_2013.pdfThis handout goes over how to navigate the SAS windows environment, read in raw data and make simple data transformations, and carry out simple descriptive statistics using SAS.brieftour.sasCommands for the brief tour of SAS handout.B600_Statistical_Graphics_2013.pdfThis handout illustrates how to generate boxplots, barcharts, scatterplots, series plots, and some others, using SAS graphics.stat_graphics.sasThis SAS command file goes along with the handout on how to generate statistical graphics using SAS.Overview of Data Management Tasks 2013.pdfThis handout illustrates how to carry out commonly used data management tasks using SAS, including creating subsets of data, dropping cases, and dropping variables, selecting cases for analysis, sorting, and merging files.datamgt.sasThis SAS command file goes along with the handout on how to carry out simple data management tasks using SAS.B600_Statistical_Procedures_2013.pdfThis handout illustrates how to carry out commonly used statistical procedures in SAS, including t-tests, chi-square tests for contingency tables, correlation, linear regression, logistic regression, Poisson regression, and some non-parametric testsstatistical_tests.sasThis SAS command file goes along with the handout on how to carry out statistical procedures using SAS.

Zipped archives containing the files to use in the Biostat 600 SAS lab can be found here:

labdata.zipZipped archive containing Blank delimited (.dat) files, Comma delimited (.csv) files, Tab delimited (.txt) files, Excel (.xls) files, SPSS portable (.por) files, and SPSS datasets (.sav files). Save this archive on the desktop, and then unzip it to a folder called labdata on your desktop.sasdata2.zipSAS version 9 data sets (.sas7bdat) and a SAS version 7 data set (.sd7 file).

Supplemental materials can be found here:fonts.sasThis 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.graph_template.sasThis little SAS command file illustrates how to set up a SAS/Graph template to make your font size larger when creating graphs using SAS Statistical Graphics.read_NA_as_missing.sasThis little SAS command file shows how you can read "NA" as a missing value when importing data from a .csv file generated by R into SAS.SAS_Functions.docThis link to a portion of the SAS documentation gives a listing of SAS functions from SAS release 9.2.

B600_Supplement_2012.pdfThis is a packet that contains more detailed information how to read instream data, how to read raw data from different types of files, and how to work with dates in SAS.instream.sasCommands for reading instream data into SAS.readdata.sasCommands for reading raw data in many different forms into SAS.date.sasCommands for reading in and setting up dates in SAS.

Homework Exercises can be found here:B600_Exercise1_2013.docThis is an exercise on reading in raw data using SAS and getting basic descriptive statistics.

Biostatistics 512: Analysis of Clustered and Longitudinal Data Using Statistical Software

Selected In-Class materials can be found here:LMM Intro.pptxThis PowerPoint presentation gives an introduction to Linear Mixed Models.Clustered_TwoLevel_A.pptxThis PowerPoint presentation gives an introduction to two-level clustered data analysis using a Linear Mixed Model.

Introduction to SAS Proc Mixed: CSCAR Workshop

The

Introduction to Proc Mixed (Longitudinal and Clustered Data) Workshopis presented by CSCAR.

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

HLM: Applications of Hierarchical Linear Models for ESIN

Instructions for using these data files:

First, create a folder on your desktop called HLM. To download a file using Internet Explorer, right-click on the file and select "Save Target As..." and place the file in the HLM folder on your desktop. Do not double-click on the file, or it will open up looking very weird (because it is a binary file). To download a file using Mozilla Firefox, right-click on the file and select "Save Link As..." and place the file in the HLM folder on your desktop. Do not double-click on the file, or I.E. will attempt to open it using SPSS.

HSB1.SAVHigh School and Beyond (Two-Level Clustered Data Example) Level 1 DatasetClick here and download to your desktop.HSB2.SAVHigh School and Beyond (Two-Level Clustered Data Example) Level 2 DatasetClick here and download to your desktop.

VOCAB1.savVocabulary Acquisition (Two-Level Longitudinal Data Example) Level 1 DatasetClick here and download to your desktop.VOCAB2.savVocabulary Acquisition (Two-Level Longitudinal Data Example) Level 2 DatasetClick here and download to your desktop.

EG1.SAVChicago Public Schools (Three-Level Data Example) Level 1 DatasetClick here and download to your desktop.EG2.SAVChicago Public Schools (Three-Level Data Example) Level 2 DatasetClick here and download to your desktop.EG3.SAVChicago Public Schools (Three-Level Data Example) Level 3 DatasetClick here and download to your desktop.

UTHAI1.SAVThai Retention (Binary Two-Level Clustered Data Example) Level 1 DatasetClick here and download to your desktop.THAI2.SAVThai Retention (Binary Two-Level Clustered Data Example) Level 2 DatasetClick here and download to your desktop.

ICPSR: Brief Tour of SAS

sasdata2.zipzipped file containing a bunch of SAS datasetsClick here and download to your desktop, and unzip to a folder called sasdata2.labdata.zipzipped file containing SAS commands, plus raw data and Excel files for the brief tour of SASClick here and download to your desktop, and unzip to a folder called labdata.

Missing Data Workshop

The

Statistical Analysis with Missing Data Workshopis presented by Professors Roderick Little and Trivellore Raghunathan from the University of Michigan Department of Biostatistics, along with CSCAR staff.

Data and commands for the afternoon lab sessions can be found herelsoa_86x.sas7bdatThis SAS dataset is used for the afternoon lab examples. Right-click on this file, and download it to a folder on your desktop called LAB (you will need to create the lab folder before you can download files to it).missingdata_session1.sasSAS command file for the first afternoon lab session. Download this file to the lab folder that you created on your desktop.missingdata_session2.sasCommand file for the second afternoon lab session using IVEware called from SAS. Download this file to the lab folder that you created on your desktop.

Biostatistics 510: Statistical Computing Packages

I teachBiostat 510in theBiostatistics Departmentat theUniversity 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 for 2010 can be found here:Click hereto get the Final Project assignment, plus datasets for each class member, and instructions on how to proceed with the final project for 2010.

General Handouts can be found here:syllabus_2010.docThe course syllabus gives information on topics to be covered, homework assignments, and the final project.Import_Excel.docThis document gives information on how to save an Excel file for use with a statistical package and how to import it into SAS.fonts.sasThis 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.docThis link to a portion of the SAS documentation gives a listing of SAS functions from SAS release 9.2.

In-Class handouts for 2010 can be found here.Click hereto get In-Class Handouts for 2010.

Homework assignments for 2010 can be found here.Click hereto get to the homework assignments for 2010.

Data sets and commands that accompany the Course Pack can be found here:b510_data.zipArchive 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.zipArchive containing SAS commands that go along with each chapter in the course pack.sasdata1.zipSAS version 6 data sets (.sd2)sasdata2.zipSAS version 8/9 data sets (.sas7bdat and .sd7)

Information on Biostat 510 from last year.Click herefor information on Biostat 510 for Winter 2009.

Regression Analysis Workshop

The

Regression Analysis Workshopis offered by CSCAR.

Data Sets for lab examples:

SAS commands and the dataset for Box-Cox transformations are included below:boxcox.sasSAS commands to figure out a good transformation for Y, using the Box-Cox method.cars.porSPSS portable file to use in Box-Cox transformations example.model_selection.sasSAS commands for model selection methods, including All Possible Regressions, Mallow's CP, and Adjusted R-Square.fitness.porSPSS portable file to use in example of model selection methods using SAS.

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.docThis handout shows examples of how to create some common statistical graphs using SAS 9.2.sgraphics.sasSAS command file to be used with the handout: Statistical_Graphics.doc.ODS Graphics Using SAS.docThis 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.sasSAS 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.sas7bdatSAS dataset to be used in the SAS graphics workshop.afifi.sas7bdatSAS dataset to be used in the SAS graphics workshop.autism.csvcomma separated raw data file to be used in the SAS graphics workshop.

Meta-Analysis Workshop

The

Meta-Analysis Workshopis presented by staff of the University Library and CSCAR.bcg2.dtaClick 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.dtaClick here to download the Stata datafile which can be used for the in-class examples on combining estimates of means and standard deviations.bcg.sasClick here to download the SAS commands which can be used to analyze the bcg data example.

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.docThis 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.

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.zipthis 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.rtfthis 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 Workshoppresented in the fall semester.labdata.zipthis 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.zipthis 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 sasdata1sasdata2.zipthis 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.sasthis 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.bostfirethis raw data file contains information about fires in the Boston Metropolitan area.da9972.macensusthis 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.datthis 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.sasSAS 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.zipZipped 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.zipSAS version 6 data sets (.sd2). Unzip the files in this archive to the c:\temp\sasdata1 folder.sasdata2.zipSAS 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 ExcelThis 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.sasThis 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.docThis 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.

Clinical Research Lab

Data Sets and handouts for lab session:demo.dtaThis is the data set we used in the first Stata Session. Right-click on this file to save it to your desktop to the Stata folder.IntroStata.pdfThis is the handout that Myra presented in the first Stata lab.Group123.xlsThis is the Excel file made from the 3 groups data. Note taht missing values for the numeric variables were indicated by a period (.) in the Excel Sheet.Group123.txtThis is the text file created from the Excel file above. The text file can be input directly into Stata using the insheet command.Exercise_May22.docThis is the *Corrected* exercise for the Stata lab on May 22nd.Clinical Research Stata Exercise May22 2007.docThis handout contains the worked problems for the lab exercise on May 22, 2007.

Introduction to SAS Workshop

The

Introduction to SAS Workshopis presented in the fall and winter semesters by CSCAR.intro_data.zipSave this archive containing data sets on the desktop. Double-click to open it. Drag files out as you need them.intro_commands.zipSave this archive containing SAS commands on the desktop. Double-click to open it. Drag files out as you need them.sasdata1.zipSAS version 6 data sets (.sd2)sasdata2.zipSAS version 8/9 data sets (.sas7bdat and .sd7)

Regression for Non-Normally Distributed Data using SAS (Generalized Linear Models)

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

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.sasSAS commands for Tecumseh Study.Lab Examples 1-5 Tecumseh Data: tecumseh.sas7bdatSAS data set for Tecumseh Study.Lab Examples 1-5 Tecumseh Data in Excel: tecumseh.xlsExcel File for Tecumseh Study.Lab Example 6 Alligator Data commands: alligator.sasSAS 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.sasSAS 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.sasData and SAS commands for the Epilepsy study.Lab Example 9: Tecumseh Study SAS commands to set up longitudinal data for GEE analysis. tecumseh_gee.sasSAS commands to set up the Tecumseh data in longitudinal form for GEE analysis.Glimmix macro. glimmix.sasSAS commands to define the glimmix macro. Download this command file to your c:\temp\glmwkshp\ folder.

Epidemiology 556:

data.xlsClick here to download the practice class data set.epid556.sasClick 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.sasClick 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 variablesClass2analysis.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 Maya!

Click hereto see pictures of our granddaughter, born April 21, 2010.

Pictures of our Japan Trip, November, 2007.

Click hereto 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! |