Accessing and Using NCHS Data: An Overview of Microdata Access Tools with SETS Demonstration

1
Accessing and Using NCHS Data An Overview of
Microdata Access Tools with SETS Demonstration
Ann Aikin, Avay Dolberry, and Brady
Hamilton 2004 Data Users Conference Hands-On
Session 34
U.S. Department of Health and Human
Services Centers for Disease Control and
Prevention National Center for Health Statistics
2
Microdata Access Tools




Kinds of Data
Ease of Use
Tool
NCHS Data Available
Level
Format
Healthy Women and Aging
?
?
Beyond 20/20
Mortality, Natality
?
?
CDC Wonder
Healthy People Objectives
?
?
DATA2010
Injuries
?
?
WISCARS
Selected NCHS sets
?
?
DataFerrett
Selected NCHS sets
?
?
SETS
3
Accessing NCHS DataUsing Beyond 20/20 Software
to Access Healthy Women, Trends in Health and
Aging, and the Asthma Data Page Tables

• Healthy Women State Trends in Health and
  Mortality
• State level data for sex, age, race/ethnicity,
  and year
• 5 Mortality Tables (42 Causes, All Causes,
  Asthma, Child and Adolescence, and CPOD)
• 5 Natality Tables
• 18 Health Behavior and Risk Factor Tables (BRFSS)

• Trends in Health and Aging
• Mortality and Life Expectancy
• Functional Status and Disability
• Risk Factors
• Injuries
• Health Care Utilization
• Population
• Living Arrangements
• Health Care Expenditures
• Asthma Data Page Coming Soon!
• 3 tablesPrevalence, Hospitalizations, and
  Mortality

4
Accessing NCHS DataUsing the Beyond 20/20
Online and Browser Tables
5
Accessing NCHS DataUsing Beyond 20/20 Browser
Online
Nesting Tables
6
Accessing NCHS DataUsing Beyond 20/20 Online
Tables, Charts and Maps
7
Accessing NCHS Data Sets Using CDC WONDER and
DATA2010CDC WONDER provides access to NCHS
Mortality (1999, 1979-98), Natality (1995-98),
and Linked Birth/Infant Death (1995-98)DATA2010
provides the most recent monitoring data for
tracking Healthy People 2010 (national and some
state data, operational definitions, and other
measurement information.)
8
Accessing NCHS Data Sets Using CDC WONDER and
DATA2010
9
Accessing NCHS DataUsing WISQARS to Access
Injury-Related NCHS Data
Non-fatal Injuries, Mortality-related Injuries,
and other Injury Data
10
Accessing NCHS DataUsing WISQARS to Access
Injury-Related NCHS Data
11
Accessing NCHS DataData Ferret and Data Web

• Application runs on the desktop, with Internet
  access to installation and data.
• Users can create crosstabs, frequencies, maps,
  and exports.
• Merge data sets with comparable fields.

12
Accessing NCHS DataData Ferret and Data Web
13
Accessing NCHS DataStatistical Export
and Tabulation System (SETS)

Over 70 SETS CDs of NCHS Data!
14
SETS Features An Overview

• Tabulating
• Frequencies
• Percents
• Weights
• Charting
• Exporting/Extracting
• SAS, SPSS, Excel, and more
• SETS QuickTab GeneratorAllows for speedier
  tabulations, without documentation files.

• SETS Designer Kit
• SETS ASCII Editor
• SETS Interface
• Searching SETS
• Documentation files
• field labels
• code labels
• Browsing Data File
• Selecting Records
• Recoding

15
SETS Features Designer Kit and Editor

• SETS Editor
• Powerful ASCII Editorfor editing large, complex
  data sets.

• SETS Designer Kit
• Build child sets
• Or design your own data sets!

16
SETS Features The SETS Interface

• The SETS InterfaceData and documentation
  available together!
• The interface is available on every SETS CD, on
  the NCHS Internet site (download), and on the
  SETS software CD.
• Revision 805 is the most current version.

17
SETS Features The SETS Interface
Searching in SETS Documents, fields and codes

18
SETS Features The SETS Interface
Browsing in SETS

19
SETS Features The SETS Interface

• Selecting Records and Recoding Fields

20
SETS Features The SETS Interface

• Tabulating Frequencies, Percents, Rates and
  Weights

21
SETS Features The SETS Interface

• Exporting and Extracting Data(SAS, SPSS, Excel,
  and more)

22
SETS Features
Browsing
Data for 2002 reveal that the rate of cesarean
delivery rose to the highest level ever reported
in the U.S. Find the method of delivery fields by
browsing the SETS 2002 Natality data file.

23
SETS Features
Searching

24
SETS Features

• Selecting Records

In working with NCHS data, careful attention
should be paid to the documentation. For
example, to match estimates reported by NCHS in
SETS, one must exclude foreign born residents
before tabulating natality data.

Exclude foreign born residents, by choosing
Records and Select from the menu. Per
documentation, use the field STRESFIP, the
operator ! (not equal) and the code 00 (foreign
born residents).
25
SETS Features

• Recoding Fields

Lets create a recode for cesarean deliveries,
based on the DELMETH5 field. To match figures
published in the Final Report, we need to combine
the primary and repeat cesarean deliveries for a
total.

26

• SETS FeaturesTabulating

27
SETS Features

• Exporting Data (SAS, SPSS, Excel, and more)

Practice exporting the 2002 Natality data to the
format of your choice.

28
Ann Aikin ? [phone] ? aia3_at_cdc.govAvay
Dolberry ? [phone] ? aym6_at_cdc.govBrady
Hamilton ? [phone] ? boh5_at_cdc.gov
Accessing and Using NCHS Data An Overview of
Microdata Access Tools with SETS
Demonstration2004 Data Users Conference
Hands-On Session 34
U.S. Department of Health and Human
Services Centers for Disease Control and
Prevention National Center for Health Statistics