Archive for the ‘SPSS’ Category

Using multiple imputation in SPSS

Wednesday, 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

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

Sampling plan files for NS-CSHCN

Sunday, 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

Thursday, 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

Wednesday, 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.

Adequacy of Prenatal Care Utilization Index

Friday, February 1st, 2008

Here is an SPSS version of the APNCU (Kotelchuck) Index program.

APNCU_SPSS

You can find the SAS program in the online MCH Library here.