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 Format Level NCHS Data Available Beyond 20/20   Healthy Women and Aging CDC Wonder   Mortality, Natality DATA2010   Healthy People Objectives WISCARS   Injuries DataFerrett   Selected NCHS sets SETS   Selected NCHS sets

3. 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 Beyond 20/20 Software to Access Healthy Women, Trends in Health and Aging, and the Asthma Data Page Tables

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

5. Accessing NCHS Data:Using Beyond 20/20 Browser Online Nesting Tables

6. Accessing NCHS Data:Using 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 Data:Using WISQARS to Access Injury-Related NCHS Data Non-fatal Injuries, Mortality-related Injuries, and other Injury Data

10. Accessing NCHS Data:Using WISQARS to Access Injury-Related NCHS Data

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

12. Accessing NCHS Data:Data Ferret and Data Web

13. Accessing NCHS Data:Statistical Export and Tabulation System (SETS) Over 70 SETS CDs of NCHS Data!

14. 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 GeneratorAllows for speedier tabulations, without documentation files. SETS Features: An Overview

15. 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: Designer Kit and Editor

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

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 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. Selecting Records 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 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. Recoding Fields

26. SETS FeaturesTabulating

27. SETS Features Practice exporting the 2002 Natality data to the format of your choice. Exporting Data (SAS, SPSS, Excel, and more…)

28. Ann Aikin (301) 458-4069aia3@cdc.govAvay Dolberry (919) 541-2700aym6@cdc.govBrady Hamilton (301) 458-4653boh5@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