Merge & Append Datasets

Purpose

Once you have downloaded data files into a SAS-accessible library, you can begin to manipulate them for your particular analysis.  Typically, an NHANES dietary dataset used for analysis will include data from 2 or more years and variables from more than one type of data file. You will need to merge the data to include variables from different dietary files and append the data to combine the years of data.

Task 1: Merge NHANES Data

Data files are generally organized by the following categories: Demographic, Examination, Laboratory, and Questionnaire. To allow for timelier releases, different data files are released at different times as they are completed. Combining variables from these different data files into one dataset is called merging.

• Key Concepts about Merging Data in NHANES
• How to Merge Data in NHANES

Task 2: Append NHANES Data

NHANES data files are released for public use in 2-year cycles. You may wish to combine multiple years, add additional observations, or combine different years of data files on the same variables. The process of combining years is called appending. This is similar to adding rows to a table.

• Key Concepts about Appending Data in NHANES
• How to Append Data in NHANES

NHANES Dietary Tutorial Home

Dietary Data Survey Orientation

Preparing a Dietary Analytic Dataset

Basic Dietary Analyses

Advanced Dietary Analyses

Additional Resources

National Center for Health Statistics
3311 Toledo Road
Hyattsville, MD 20782
Phone: 1-866-441-NCHS (6247)
For data inquiries, use
nchsquery@cdc.gov

Problems or comments about the Tutorial?
Email the Tutorial Team: NHANESWebTutorial@cdc.gov

Centers for Disease Control and Prevention, 1600 Clifton Rd, Atlanta, GA 30333, U.S.A
Tel: (404) 639-3311 / Public Inquiries: (404) 639-3534 / (800) 311-3435