# Presentation: 271672

## 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**

## Microdata Access Tools

**  **

**  **

**  **

**  **

**Selected NCHS sets**

****

****

**SETS**

**Selected NCHS sets**

****

****

**DataFerrett**

**Injuries **

****

****

**WISCARS**

**Healthy People Objectives**

****

****

**DATA2010**

**Mortality, Natality**

****

****

**CDC Wonder**

**Healthy Women and Aging**

****

****

**Beyond 20/20 **

**NCHS Data Available**

**Kinds of Data**

**Level **

**Ease of ****Use**

**Format**

**Tool**

## Accessing NCHS Data:Using 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 tables—Prevalence, Hospitalizations, and Mortality

## Accessing NCHS Data:Using the Beyond 20/20 Online and Browser Tables

## Accessing NCHS Data:Using Beyond 20/20 Browser Online

**Accessing NCHS Data:****Using Beyond 20/20 Browser Online**

**Nesting Tables**

## Accessing NCHS Data:Using Beyond 20/20 Online

**Tables, Charts and Maps**

## Accessing NCHS Data Sets: Using CDC WONDER and DATA2010CDC 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.)

## Accessing NCHS Data Sets: Using CDC WONDER and DATA2010

## Accessing NCHS Data:Using WISQARS to Access Injury-Related NCHS Data

**Non-fatal Injuries, Mortality-related Injuries, and other Injury Data**

## Accessing NCHS Data:Using WISQARS to Access Injury-Related NCHS Data

## Accessing NCHS Data:Data 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.

## Accessing NCHS Data:Data Ferret and Data Web

##           Accessing NCHS Data:Statistical Export and Tabulation System (SETS)

**Over 70 SETS CDs of NCHS Data!**

## SETS Features: An Overview

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

- Tabulating
**Frequencies**
**Percents**
**Weights**
- Charting
- Exporting/Extracting
**SAS, SPSS, Excel, and more...**
**SETS QuickTab Generator**Allows for speedier tabulations, without documentation files.

## SETS Features: Designer Kit and Editor

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

**SETS Editor**
- Powerful ASCII Editor—for editing large, complex data sets.

## SETS Features: The SETS Interface

- The SETS Interface—Data 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.

## SETS Features: The SETS Interface

**Searching in SETS: Documents, fields ****and codes**

## SETS Features: The SETS Interface

**Browsing in SETS**

## SETS Features: The SETS Interface

**Selecting Records and Recoding Fields**

## SETS Features: The SETS Interface

**Tabulating: Frequencies, Percents, ****Rates and Weights**

## SETS Features: The SETS Interface

**	****Exporting and Extracting Data****(SAS, SPSS, Excel, ****and more...)**

## 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.

## SETS Features

**Searching**

## 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).**

## SETS Features

**Recoding Fields**

- Let’s 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.

## SETS FeaturesTabulating

## SETS Features

**	****Exporting Data (SAS, SPSS, Excel, and more...)**

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

## Accessing and Using NCHS Data: An Overview of Microdata Access Tools with SETS Demonstration2004 Data Users Conference Hands-On Session #34

**Accessing and Using NCHS Data: An Overview of Microdata Access Tools with SETS Demonstration****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**

**Ann Aikin**** ******** ****(301) 458-4069**	**** _**aia3@cdc.gov**_**Avay Dolberry**** ******** ****(919) 541-2700**	**** _**aym6@cdc.gov**_**Brady Hamilton**** ******** ****(301) 458-4653**	**** _**boh5@cdc.gov**_