Title: Accessing and Using NCHS Data: An Overview of Microdata Access Tools with SETS Demonstration
1Accessing 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
2Microdata 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
3Accessing 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
4Accessing NCHS DataUsing the Beyond 20/20
Online and Browser Tables
5Accessing NCHS DataUsing Beyond 20/20 Browser
Online
Nesting Tables
6Accessing NCHS DataUsing Beyond 20/20 Online
Tables, Charts and Maps
7Accessing 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.)
8Accessing NCHS Data Sets Using CDC WONDER and
DATA2010
9Accessing NCHS DataUsing WISQARS to Access
Injury-Related NCHS Data
Non-fatal Injuries, Mortality-related Injuries,
and other Injury Data
10Accessing NCHS DataUsing WISQARS to Access
Injury-Related NCHS Data
11Accessing 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.
12Accessing NCHS DataData Ferret and Data Web
13 Accessing NCHS DataStatistical Export
and Tabulation System (SETS)
Over 70 SETS CDs of NCHS Data!
14SETS 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
15SETS 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!
16SETS 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.
17SETS Features The SETS Interface
Searching in SETS Documents, fields and codes
18SETS Features The SETS Interface
Browsing in SETS
19SETS Features The SETS Interface
- Selecting Records and Recoding Fields
20SETS Features The SETS Interface
- Tabulating Frequencies, Percents, Rates and
Weights
21SETS Features The SETS Interface
- Exporting and Extracting Data(SAS, SPSS, Excel,
and more)
22SETS 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.
23SETS Features
Searching
24SETS Features
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).
25SETS Features
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 27SETS Features
- Exporting Data (SAS, SPSS, Excel, and more)
Practice exporting the 2002 Natality data to the
format of your choice.
28Ann Aikin ? (301) 458-4069 ? aia3_at_cdc.govAvay
Dolberry ? (919) 541-2700 ? aym6_at_cdc.govBrady
Hamilton ? (301) 458-4653 ? 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