Course F - 45 hours over 15 weeks

Frequency Distribution

Example 14 Week Course

Health Services Research Using SAS^®

Raymond R. Arons, Dr. P.H., M.P.H.

1. Course Description

This is an applied course aimed at providing an overview of the major public access large scale health care data sets available on federal, state and local levels and second to instruct the student in SAS best practices analytical and statistical methods required to study these data. Included are: (1) variable identifications and definitions; (2) record layouts; (3) data set sizes and analysis restrictions; (4) coding methods; (5) manipulation of these data on PC SAS Version 9.2; (6) developing a working knowledge of SAS syntax and lastly (7) fourteen two hour SAS workshops featuring hands-on SAS coding aimed at honing computer statistical skills and working on selected research project.

Public access data sets on the web obtained from federal and state agencies allows the serious researcher the ability to ask and answer major research questions using secondary data. The ability to analyze these national survey data or large national health service research data sets is a unique skill set that provides the health care practitioner a unique sense of empowerment.

2. Major Teaching Methods and Organization of the Course

The course consists of lectures, seminar discussions, readings, and fourteen 3 hour classes.

Class 1- Introduction Health Services Research Using SAS^®

An overview of the goals and objectives of the course and the means by which they will be achieved.

SAS Workshop 1 - Review of basic data and SAS 9.2 coding syntax using The California Office of Statewide Planning and Development State Discharge Data (OSPHD) The research question will be who are the homeless treated in California Hospitals and what are the diseases that they present. Code SAS 9.2 syntax including the infile, data , input, and indicator variables.

Homework 1 assigned

Class 2- OSHPD Analysis 2

Overview of computer coded health information, including definitions of ICD-9-CM disease and procedures and diagnosis-related groupings (DRGs).

SAS Workshop 2 - Further use of SAS 9.2 syntax and coding using OSPHD data and continue to prepare an analysis of the homeless discharges from California hospitals descriptive and predictive findings. PROC MEANS, PROC TABULATE and PROC REG will be reviewed.

Prepare a summary of the findings for homework 2. Homework 1 is due.

Class 3 – The New Jersey UB 92

A description of the New Jersey UB 92 Data Set including , variable definitions, data dictionaries, record layouts The research question will be describe the demographics and diseases presented by Hispanic discharges from New Jersey Hospitals.

SAS Workshop 3 - Using NJUB92 data prepare the SAS 9.2 syntax to study New Jerseys Hispanic population along with descriptive and predictive findings of this population.

Code SAS 9.2 syntax including the infile, data , input, and indicator variables. Furthermore, produce code for the analysis of the Hispanic discharges with descriptive and predictive findings using PROC MEANS, PROC TABULATE , PROC REG and PROC LOGISTIC.

Prepare a summary of findings for homework 3. Homework 2 is due.

Class 4 - The Organ Procurement and Transplant Network (OPTN) Liver Transplantation Data

The OPTN liver transplant data has 88,636 transplantations that have occurred in the nation from 1977 through 2006 including A description of this data set along with, variable definitions, data dictionaries, record layouts The research question will be describe the demographics and diseases associated with the nation’s recipients of liver transplantations in the United States..

SAS Workshop 4 – Write SAS code to identify the demographics and clinical variables of liver the nation’s transplant patients. The analysis will include the range of clinical causes that resulted in end stage hepatic failure and risk factors attributed to HEP C. Code SAS 9.2 syntax including the infile, data , input, and indicator variables. Furthermore, produce code for the analysis of the Hispanic discharges with descriptive and predictive findings using PROC MEANS, PROC TABULATE , PROC REG and PROC LOGISTIC. Prepare a summary of findings for homework 4.Homework 3 is due.

Class 5 – The National Hospital Medical Ambulatory Care Survey (NHAMCS)

A detailed overview of NHAMCS with 100 million of the nations Emergence Room Visits (ERs). A description of this data set along with, variable definitions, data dictionaries, record layouts The research question will be describe the demographics and diseases associated motor vehicle accidents treated in the nation’s emergency departments.

SAS Workshop 5 – Code using SAS 9.2 syntax including the infile, data , input, and indicator variables. Furthermore, produce code for the analysis of the ED motor vehicle accidents that arrive in the ED with descriptive and predictive findings using PROC SURVEYMEANS, PROC TABULATE , PROC SURVEYREG and PROC SURVEYLOGISTIC. Prepare a summary of findings for homework 5.Homework 4 is due.

Class 6 – The National Health Interview Survey (NHIS)

A detailed overview of NHIS and its projected 280 million interviews using randomized complex sampling design of households, adults and children in the measuring the nations health. A description of this data set along with, variable definitions, data dictionaries, record layouts The research question will be describe the demographics and diseases associated children identified as learning disables along with their identified risk factors.

SAS Workshop 6 – Code using SAS 9.2 syntax including the infile, data , input, and indicator variables. Furthermore, produce code for the analysis of the nation’s youngsters with disabilities along with demographic, diagnoses and other descriptive and predictive findings using PROC SURVEYMEANS, PROC TABULATE , PROC SURVEYREG and PROC SURVEYLOGISTIC. Prepare a summary of findings for homework 6. Homework 5 is due.

Class 7 - The National Health and Nutrition Examination Study (NHANES)

A detailed overview of The National Health and Nutrition Examination Study (NHANES) 1999-2002 survey, the most important extensive survey in the US measuring the health of the nation. This occurs interviewing 35,000 survey participants and over 2,000 questions from a randomized multistage stratified population sample. The research question is what are theCardiovascular Disease and Modification of Traditional Cardiovascular Risk Factors in Early Chronic Kidney Disease.

SAS Workshop 5 – Code using SAS 9.2 syntax including the infile, data , input, and indicator variables. Furthermore, produce code for the analysis of respondents with chronic kidney disease (CKD) and associated cardiac risk factors. They include a range of clinical and demographic variables associated with CKD, demographics such as age, race, and gender, cardiac risk factors such as obesity, history of cardiac disease, and lastly measurements of kidney functions, blood pressure, diabetes and cholesterol control using PROC SURVEYMEANS, PROC TABULATE , PROC SURVEYREG and PROC SURVEYLOGISTIC. Prepare a summary of findings for

Homework 7. Homework 6 is due.

Class 8 –Review of Statistical Methods SAS 9.2 Syntax and identify any concerns

And questions.

Homework 7 is due.

Review semesters work and identify research project that will be worked on over the next five sessions.

Class 9 – Research and Analysis on Selected Projects -SAS Workshop 9

Class 10 - Research and Analysis on Selected Projects -SAS Workshop 10

Class 11 -Research and Analysis on Selected Projects -SAS Workshop 11

Class 12 -Research and Analysis on Selected Projects -SAS Workshop 12

Class 13 -Research and Analysis on Selected Projects -SAS Workshop 13

Class 14 - Completion and review of final project.

Summary

Health Services Research Using SAS has as its goal achieving the following:

Provide the awareness and skills in applied data methods using current information from federal, state and local health care providers and agencies that set today’s health care research agendas and policies

Complements a range of methods courses to prepare students to advance in the work force and/or move to a methods/practitioner based doctoral program.

Gives the students access to a data to study a range of topics relevant to current health care issues that are changing daily.

The student will master the following SAS procedures: TITLES; INFILE; DATA STATEMENT; INPUT STATEMENTS; IF STATEMENTS; FORMATS, LABLES LOGICAL RECORD LENGTH; OBS; MISSOVER; INDICATOR VARIABLES ; TRUTH LOGIC: PROC PRINT; PROC FREQ; PROC MEANS, PROC TABULATE; PROC LOGISTIC; PROC REG; IMPORT EXCEL FILES; PROC PLOT PROC GRAPH; CREATE LIBRARY’S; READ WORK FILES AND MINUPULATE THEM, THE POWER OF THE WHERE AND CLASS STATEMENTS, MERGING MULTIPLE FILES along with PROC SURVEYMEANS, PROC SURVEYREG and PROC SURVEYLOGIST for randomized complex multi-stage survey data analysis and other SAS syntax as needed.

Introduction, Research Question,

Descriptive Statistics,

Exploratory Data Analysis for Linear Regression,

Linear Model Selection, Assessment and Interpretation,

Exploratory Data for Logistic Regression Analysis,

Logistic Model Selection, Assessment and Interpretation and Data set Summary

Required readings:

Arons, RR. Health Services Research Using SAS^®

Course F - 45 hours over 15 weeks

Summary

Health Services Research Using SAS has as its goal achieving the following:

Recommended Readings