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 <<<
Tags: cesarean, delivery route, Maternal Quality Indicators, outcomes, risk
Posted in Hospital Discharge, SAS | Comments Off
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.
Posted in Site Information | No Comments »
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!
Tags: multiple imputation
Posted in Complex sample surveys, National Survey of Children w Special Health Care Needs, National Survey of Children's Health, SPSS | No Comments »
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
Posted in Hospital Discharge, SPSS | No Comments »
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
Posted in Complex sample surveys, National Survey of Children w Special Health Care Needs, SPSS | No Comments »
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).
Posted in Complex sample surveys, National Survey of Children w Special Health Care Needs, National Survey of Children's Health, SAS, SPSS | No Comments »
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.
Posted in Birth, SAS, SPSS, Stata | No Comments »
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).
Posted in Hospital Discharge, SAS | No Comments »
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)
Posted in Birth, SAS | No Comments »