I am phasing out this site and rolling the content and functionality into a more comprehensive site at mchepi.org.
Site change coming
January 9th, 2011Maternal Quality Indicators
July 2nd, 2009The 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
March 26th, 2009You can find many interesting SAS programs from the University of Manitoba Centre for Health Policy here.
Hit List
March 18th, 2009What 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, 2009There 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, 2008This 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.
Sampling plan files for NS-CSHCN
November 23rd, 2008Attached 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.
NS-CH and NS-CSHCN SAS/SPSS codebooks
May 15th, 2008National birth data files and programs
April 2nd, 2008Although 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, 2008The 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).