Maternal Quality Indicators

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: maternal_quality_indicators_v1-1

* —————————————————————- ;
* 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.
*
* >>>last updated: 060709; used in hospital discharge data through 2005;
Data after 2005 may require additional codes secondary to new ICD9 variables <<<

Health-related SAS programs

March 26th, 2009

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

Hit List

March 18th, 2009

What syntax/programs would you like to find on this site?  Here are some I’d like to see added — anyone willing to share their work?

1. SPSS and Stata versions of the NCHS gestational age SAS programs.

2.  SPSS and Stata versions of the NCHS month prenatal care began SAS program.

3.  GINDEX

4.  PPOR examples.

Please send me a note with suggestions for additions to this list. These are just a few that came to mind quickly, but I’m certain there are many more useful programs we can share with each other.

Using multiple imputation in SPSS

March 18th, 2009

There are some guides and syntax for using multiple imputation in SPSS that can be found here.  You can find some information on the SPSS Developer site too.

Update: My take on using multiply imputed values in SPSS:  It is way too much of a hassle compared to other programs (e.g. Stata).  I spent hours tailoring one of the programs linked above, then was able to have it done in Stata in minutes.  The output was more understandable and included more useful information.  While people who are very good SPSS programmers might be able to do it reasonably quickly, this was not at all my experience.  Bottom line: I have not found an easy way to use multiply imputed values within a complex sample survey in SPSS (my work was with the NS-CSHCN).  Please let me know if you find otherwise!

Count ICDx codes

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

Sampling plan files for NS-CSHCN

November 23rd, 2008

Attached are sampling plan files that can be used with the SPSS Complex Samples module when working with the National Survey of Children with Special Health Care Needs.  I developed files on my own, but then contacted NCHS just to be sure I did it correctly (I did).  These are the files they sent me.

Interview file

Screener file

Household file

NS-CH and NS-CSHCN SAS/SPSS codebooks

May 15th, 2008

Here is a link to a page with SPSS and SAS codebooks for the National Survey of Children with Special Health Care Needs (click).

And here is a link to a page with a SAS codebook for the National Survey of Children’s Health (click).

National birth data files and programs

April 2nd, 2008

Although there are several good online query systems (e.g. NCHS and MOD), here is one site I’ve found useful for downloading programs related to formatting the NCHS birth data files.

National Bureau of Economic Research
1968-2005 U.S. birth data files from NCHS, but with some formatting done and input programs available. Many other related documents available on this page. A shorter range of years of data files are available for the territories.

AHRQ Quality Indicators

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

NCHS Birth Data Programs

February 5th, 2008

Here are some useful SAS programs I received today from Joyce Martin at the National Center for Health Statistics. Please contact her with any questions at 301-458-4362 or jcm9@cdc.gov.

New Format Gestational Age

Old Format Gestational Age

Month Prenatal Care Began (2003 revised certificate only)