Dietary Screener Questionnaire in the NHIS CCS 2010: Computed Variables
NOTE: The dietary variables provided here are in their natural units. For most analyses, however, they must be transformed first, to approximate normal distributions. For fruits and vegetables, dairy, added sugars from sugar-sweetened beverages, and whole grains, use the square-root transformation. For added sugars, use the cube-root transformation. For fiber and calcium, use the quarter-root transformation. After analyses, the result variables can be back-transformed for easier interpretation.
The computed diet variables for the NHIS CCS 2010 DSQ are available for download in two formats: SAS transport [V9X - 3.29 MB] and comma-separated values [ZIP - 1 MB]. The files include the following variables:
- HHX - Household identifier
- FMX - Family serial number
- FPX - Person number (in family)
- FCE - Cup equivalents of fruits per day
- VCE - Cup equivalents of vegetables per day (including legumes and French fries)
- FVCE - Cup equivalents of fruits and vegetables (including legumes and French fries) per day
- FVCENoFF - Cup equivalents of fruits and vegetables (including legumes and excluding French fries) per day
- Fiber - Fiber (g) per day
- Dairy - Cup equivalents of dairy per day
- Calcium - Calcium (mg) per day
- Sugar - Added sugars (tsp) per day
- SSB - Added sugars (tsp) from sugar-sweetened beverages
- WHGrain- Ounce equivalents of whole grains per day
The datasets are sorted in ascending order by the ID variables HHX, FMX, and FPX. All numeric variables have been rounded to the nearest 0.000001.
- Comma-separated Values (CSV) File [ZIP - 1 MB] - This zip file contains the comma-separated values file, which includes 13 variables, 27,157 records, and an additional record for the variable names.
SAS Transport File [V9X - 3.4 MB] - The SAS transport file includes 27,157 records and 13 variables. To access the SAS dataset, unzip the file, then use proc cimport. For example:
proc cimport file='nhis2010dietvars.?.v9x' data=dietvars;
- SAS Program [SAS - 18 KB] - This is the SAS program that created the dataset. This is for reference, only; there should be no need to run this program.
- Supplement Excel Files [ZIP - 51 KB] - This zip file contains 4 Excel files that are required to run the SAS program.