Reviewing & Cleaning ASA24® Data

General Guidelines for Reviewing & Cleaning Data

Researchers using the ASA24 system should consider how best to review and clean ASA24 data based on individual study needs and interests. The following document provides general guidelines from the National Cancer Institute (NCI) regarding how to review and edit ASA24 data.

Importing ASA24-2016 CSV Files into SAS

The ASA24 system provides Researchers with their data in CSV format. CSV files can be imported into any number of software applications for data review, cleaning, and analysis purposes. Since SAS is a commonly used software program, we have provided SAS code to assist Researchers with importing ASA24 CSV files into SAS. Researchers who use this SAS code should verify the SAS log and the resulting SAS datasets have correctly processed your study’s CSV files.

Calculating Food Patterns Equivalents Database (FPED) Food Group Equivalents

The underlying food group databases for ASA24 versions prior to ASA24-2016 are not directly comparable (see a table comparing the features of all versions of ASA24). The 2011, 2012 and 2014 versions of ASA24 provided food group output from the MyPyramid Equivalents Database (MPED). Below, we provide SAS code which computes food group variables into the more recent Food Patterns Equivalents Database (FPED) which was used in ASA24-2016. After this calculation is complete, food group data from ASA24 2011, 2012, and 2014 can be harmonized with food group data from ASA24-2016; and can be used to compute the Healthy Eating Index-2015 (HEI-2015) and the Healthy Eating Index-2010 (HEI-2010).

Nutrient database variables did not change between older versions of ASA24 and ASA24-2016, therefore, no conversion code is required for harmonization. However, while the nutrient variables and units have not changed from one version of ASA24 to another, there have been updates to the underlying Food and Nutrient Database for Dietary Studies (FNDDS). This may result in some slight variation in actual nutrient and food group amounts due to updates to the data.

There are two SAS programs provided.  The first generates FPED for ASA24-2011/12 and the second for ASA24-2014.  The SAS programs use the Excel file, also provided below. Comments in the SAS program indicate where it needs to be edited to provide the folder location of ASA24 data relevant to the user’s own network.

SAS Code for the Beta version of ASA24

Two SAS programs are available to allow Researchers to update data files from the Beta version of the ASA24 system.

The ASA24_Beta_Update_Nutrients program [ZIP - 3 MB] updates nutrient data from version 1.0 of the Food and Nutrient Database for Dietary Studies (FNDDS) to version 4.1, which USDA used to process the dietary intake data from the 2007-08 National Health and Nutrition Examination Survey (NHANES). The program uses Beta version Individual Foods and Nutrients (INF) and Daily Total Nutrients (TN) files as input and includes steps to replace food codes from FNDDS 1.0 with FNDDS 4.1 codes where necessary, updates data for all nutrients in the Beta files, and adds data for 4 nutrients. A food description variable is also added. The resulting updated INF and TN files are consistent with the output files available from ASA24-2011 (formerly referred to as Version 1). The updated files can be further analyzed by the Researcher or merged with data from ASA24-2011.

Researchers may also wish to update MyPyramid Equivalents Database (MPED) values in the Individual Foods and MyPyramid Equivalents (INFMYPHEI) and Daily Total MyPyramid Equivalents (TNMYPHEI) Beta files. The ASA24_Beta_Update_Nutrients_MyP program [ZIP - 3.66 MB] applies the nutrient updates noted above and also updates MyPyramid Equivalents Database (MPED) variables from version 1.0 to an updated version based on MPED, version 2.0 and the USDA's Center for Nutrition Policy and Promotion's MPED Addendum; nutritionists on the ASA24 team imputed values for nine food codes for which MyPyramid Equivalents have not yet been assigned by USDA.
These programs have been tested using SAS, version 9.2.

Return to Top

ASA24 is a registered trademark of HHS.