Archive for the ‘Hospital Discharge’ Category

Maternal Quality Indicators

Thursday, July 2nd, 2009

The Maternal Quality Indicators group has been kind enough to annotate and share their SAS code for delivery route, cesarean indication, delivery risk group and delivery outcomes from inpatient delivery records.  See below for an excerpt from the SAS program introduction.  Click this link for the entire program and introduction: mqi_codes_annotated-071509

* —————————————————————- ;
* Copyright information: The Maternal Quality Indicators (MQI) Group,
Moshe Fridman, PhD
Kimberly Gregory, MD, MPH
Lisa Korst, MD, PhD
Michael Lu, MD, MPH ;
************************************************ ;
*=====================================;
* Title: MQI SAS Code for delivery route, cesarean indication,
* delivery risk group and delivery outcomes.
*
* Description:
* Define variables for delivery route, cesarean indication,
* delivery risk group and delivery outcomes from inpatient
* delivery records. Uses ICD9 diagnosis and procedure codes from
* administrative hospital discharge data.

Health-related SAS programs

Thursday, March 26th, 2009

You can find many interesting SAS programs from the University of Manitoba Centre for Health Policy here.

Count ICDx codes

Sunday, November 23rd, 2008

This program automates most of the writing of a longer program to create count variables for each ICD code of interest.  You start with an Excel or other file with two vars/columns.  One with each code of interest, and a corresponding one with the label for each of those codes.  You import this data into SPSS (can use the import wizard).  Then run the attached SPSS program to create the syntax for a potentially much longer program which will count the occurrences of each ICD code.  You just copy and paste the variable *values* of this program into another syntax file to create this longer program.  Then aggregate the counts however you like.  I’m sure there are many other ways to do this, but this seemed novel enough to share.

write-syntax-using-syntax

AHRQ Quality Indicators

Friday, March 28th, 2008

The Agency for Healthcare Research and Quality (AHRQ) Quality Indicators (QIs) are measures of health care quality that make use of readily available hospital inpatient administrative data.  SAS and Windows programs are available on the AHRQ QI website (click).