Title: Dietary Supplement Database - File 3: Supplement Information
(DSQ3_E
)
Contact Number: 1-866-441-NCHS
Years of Content: 1999
- 2008
First Published: July, 2010
Revised:
NA
Access Constraints: None
Use Constraints: None
Geographic Coverage: National
Subject:The Dietary Supplement Information datasets contains additional product data on the dietary supplement(s) and non-prescription antacids containing calcium and/or magnesium reported by survey participants in the Dietary Supplement and Non-Prescription Antacid subsections of the Household Interview.
Record Source: NHANES 1999
- 2008
Survey Methodology: NHANES 1999
- 2008
is a stratified multistage probability sample of the civilian non-institutionalized population of the U.S.
Medium: NHANES Web site; SAS transport files
The NHANES Dietary Supplement Database (NHANES-DSD) contains detailed information on the dietary supplements (DS) and non-prescription antacids containing calcium and/or magnesium (antacids) reported by survey participants since NHANES 1999. The NHANES-DSD release consists of three datasets (DSQ3_E, DSQ4_E, and DSQ5_E) that contain information on products.
Dietary supplement information from the in-house NCHS Product Label Database (PLD) is publicly released in three files that make up the NHANES-DSD. Previously, the NHANES-DSD was publicly released every 2-year cycle and only contained products that were reported within that two year cycle. In order to make the product information more comprehensive and organized, files will now be released in the same format as previous releases, but as comprehensive files. These files will incorporate all products that have been reported by respondents since 1999 from the PLD. With subsequent releases, new products reported will be appended to the NHANES-DSD files.
The in-house PLD database is maintained by NCHS nutritionists’. NCHS attempts to obtain a product label for all dietary supplements or antacids reported by participants from sources such as the manufacturer or retailer, the Internet, company catalogs, and the Physician’s Desk Reference (PDR). Selected label information is then entered into the PLD including, but not limited to: supplement name; manufacturer and/or distributor; serving size; form of serving size; and ingredients and amounts. The ingredient information entered into the database is taken directly from the supplement facts box on the label or carton. The PLD is used to assist with data editing and then publicly released in three data files (DSQ3_E, DSQ4_E, and DSQ5_E).
In addition to entering labels into the PLD database, NCHS created generic and default dietary supplements and antacids, which is also maintained in the database. Generics are created in the database when we have information about a reported supplement such as the strength of all ingredients were known, i.e. one which had no brand name. These were generally single ingredient supplements which included a strength (e.g. vitamin C 500 mg) or multiple vitamins and/or mineral supplements made by a private label manufacturer that was known to us and for which we had a label with identical ingredients and strengths (e.g. brand X all-purpose multivitamin was reported, and we had a label for brand Y, made by the same manufacturer). When all ingredient strengths were not known, a default supplement was created in the database. Defaults were created for single ingredient and multiple ingredient supplements based on our own data of most frequently reported supplements of that type, based on the survey cycle in which the data was collected. Created default products and the actual products or strengths that were assigned to these defaults are listed in the documentation for the files associated with participants’ use of dietary supplements, located on the NHANES website: http://wwwn.cdc.gov/nchs/nhanes/search/nhanes07_08.aspx.
The in-house PLD was used for processing and editing of the dietary supplement data since 1999.
Variables pulled directly from the in-house PLD
DSDSUPP: Name of Supplement
This is the name from the front of the product label. The brand name is generally entered first (i.e. Nature’s Way) and then the actual product name (i.e. lutein). Information such as the strength (i.e. 60 mg extract) of the product and other qualifiers that help distinguish a product from a similar product (i.e. mega, super, high potency, time release, chewable, extract) are also listed if they are on the front of the product label. Words like “dietary supplement” and health claims are not entered as part of the name.
DSDSUPID: Supplement ID Number
Supplement ID is a 10 digit identifier assigned to each product entered into the in-house PLD. All identifiable products have a supplement ID beginning with the number ‘1’. The next 3 digits (positions 2-4) are ‘888’ if the supplement was created by NCHS as a generic or default product; otherwise the digits in positions 2-4 are coded ‘000’. The next 4 digits (positions 5-8) are sequentially assigned by the system for each product. The last 2 digits (positions 9-10) indicate formulations of the same supplement: the first formulation entered into the database = 00, the first reformulation = 01, the next = 02, etc. Note that these are reformulations of the same product. Different versions of products(e.g. liquid vs. tablet, with iron vs. without iron, regular vs. high potency) are considered as different products thus have different 4 digit numbers in positions 5 to 8. When a product name was entered as "no product information available", "refused" or "don't know", its ID number starts with a string of 6's.
DSDSRCE: Supplement Information Source
The source of each product label is recorded into the PLD. Generic and default products do not have a source code.
DSDTYPE: Formulation Type
The type of formula is recorded into the database. The formula types are: infant/pediatric formulation, prenatal formulation, mature formulation, or standard formulation. Products are coded as infant/pediatric when the product name states "infant, children, child, or kid/s" or has an indication in the title, label, or the form (e.g. animal shapes) of the supplement that it is intended for children. If this is not the case, but the suggested dose or directions indicate dosage for children only, then the code is infant/pediatric, but if dosages for adults are also included, then the product is coded as standard. Products are coded as Prenatal when the product name states prenatal or a derivative of this name, or has an indication in the title or label that it is intended for pregnant women. If this is not the case, but the suggested dosage or directions indicate dosage for pregnant women only, the product is coded as a prenatal, but if dosages for non-pregnant adults are also included, the product is coded as standard. Products are coded as Geriatric when the product name or label includes words such as "mature, senior, geriatric, post-menopausal, silver" or indicates with other words that it is intended for individuals 50 years and over. All other products are coded as standard.
DSDSERVQ: Serving Size Quantity
This is the “serving size quantity”, which is recorded from the product label’s supplement facts panel for which the nutrient amounts are based on.
DSDSERVU: Serving Size Unit
This is the “serving size unit”, which is recorded from the product label’s supplement facts panel.
DSDINGID: Ingredient ID
This is the unique ingredient ID created by the PLD for each ingredient recorded from the product label’s supplement facts panel.
DSDINGR: Ingredient name
Ingredient names are recorded from the product label’s supplement facts panel.
DSDOPER: Ingredient operator
This is a symbol =, < , or > that comes from the product label’s supplement facts panel.
DSDQTY: Ingredient quantity
Ingredient quantity is recorded for each ingredient listed from the product label’s supplement facts panel. Some nutrient amounts are for a nutrient compound (generally a foreign-made product or an antacid) and these must be converted to an elemental nutrient amount (See Appendix 2 for recommended conversions).
DSDUNIT: Ingredient unit
Ingredient unit is recorded for each ingredient listed from the product label’s supplement facts panel.
DSDCAT: Ingredient category
There are ingredient categories: Vitamin, Mineral, Botanical, Others, Amino Acid. These are assigned by NCHS staff. (Please see Appendix 1: Rules For Classifying Ingredients)
DSDBCNAM: Blend component name
These are the ingredient names found within a blend. Blends in products will not give the actual breakdown of ingredient quantities in the blend. The ingredients will usually just be listed, and most of the time a total blend amount is given. The blend ingredients are released in file DSQ5_E.
DSDBCLID: Blend component id
These are unique ingredient ID numbers for blend ingredients created by the PLD.
DSDBCCAT: Blend component category
There are ingredient categories: Vitamin, Mineral, Botanical, Others, Amino Acid. These are assigned by NCHS staff. (Please see Appendix 1: Rules For Classifying Ingredients)
Variables created for the NHANES-DSD public release files
DSDBLFLG: Blend Flag
This indicator variable denotes whether an ingredient is a blend or not a blend. If the ingredient is a blend, then information from file DSQ5_E is needed.
DSDCNTV: number of vitamin(s) in supplement
This variable indicates the number of vitamins in the supplement, including in blends. All ingredients categorized as “vitamins” in variables DSDCAT and DSDBCCAT are added up to get the number of vitamins in the product. If a product has the same vitamin listed as an ingredient as well as a blend, this vitamin was only counted once. Ingredients that are categorized as a blend (DSDBLFLG=1) in file DSQ4_E are not included in this count, but the ingredients within the blend are counted (blend ingredients in file DSQ5_E).
DSDCNTM: number of mineral(s) in supplement
This variable indicates the number of minerals in the supplement, including in blends. All ingredients categorized as “minerals” in variables DSDCAT and DSDBCCAT are added up to get the number of minerals in the product. If a product has the same mineral listed as an ingredient as well as a blend, this mineral was only counted once. Ingredients that are categorized as a blend (DSDBLFLG=1) in file DSQ4_E are not included in this count, but the ingredients within the blend are counted (blend ingredients in file DSQ5_E).
DSDCNTA: number of amino acid(s) in supplement
This variable indicates the number of amino acids in the supplement, including in blends. All ingredients categorized as “amino acids” in variables DSDCAT and DSDBCCAT are added up to get the number of amino acids in the product. Ingredients that are categorized as a blend (DSDBLFLG=1) in file DSQ4_E are not included in this count, but the ingredients within the blend are counted (blend ingredients in file DSQ5_E).
DSDCNTB: number of botanical(s) in supplement
This variable indicates the number of botanicals in the supplement, including in blends. All ingredients categorized as “botanicals” in variables DSDCAT and DSDBCCAT are added up to get the number of botanicals in the product. Ingredients that are categorized as a blend (DSDBLFLG=1) in file DSQ4_E are not included in this count, but the ingredients within the blend are counted (blend ingredients in file DSQ5_E).
DSDCNTO: number of other ingredients in supplement
This variable indicates the number of other ingredients in the supplement, including in blends. All ingredients categorized as “other” in variables DSDCAT and DSDBCCAT are added up to get the number of other ingredients in the product. Ingredients that are categorized as a blend (DSDBLFLG=1) in file DSQ4_E are not included in this count, but the ingredients within the blend are counted (blend ingredients in file DSQ5_E).
The NCHS-DSD file may be linked to both the Household dietary supplement data use files and the 24-hour dietary recall interview dietary supplement files by the supplement ID number (DSDSUPID).
Currently, NCHS-DSD contains information on all DS and antacids reported since 1999. New products will be appended as they are reported in future data releases. There are three files. The 'Supplement Information' file (DSQ3_E) and the 'Ingredient Information' file (DSQ4_E) can be linked by supplement ID number (DSDSUPID) which is a unique product identifier. The 'Ingredient Information' file (DSQ4_E) and the 'Supplement Blend' file (DSQ5_E) can then be linked by the ingredient ID number (DSDINGID).
Layout of DSQ_DSD
| Variable Name | Label |
|---|---|
| DSDSUPID | Supplement ID number |
| DSDSUPP | Supplement name |
| DSDSRCE | Supplement information source |
| DSDTYPE | Formulation type |
| DSDSERVQ | Serving size quantity |
| DSDSERVU | Serving size unit |
| DSDCNTV | Count of vitamins in the supplement |
| DSDCNTM | Count of minerals in the supplement |
| DSDCNTA | Count of amino acids in the supplement |
| DSDCNTB | Count of botanicals in the supplement |
| DSDCNTO | Count of other ingredients in the supplement |
| Variable Name | Label |
|---|---|
| DSQSUPID | Supplement ID number |
| DSQSUPP | Supplement name |
| DSDINGID | Ingredient ID number |
| DSDINGR | Ingredient name |
| DSDOPER | Ingredient operator (<, =, >) |
| DSDQTY | Ingredient quantity |
| DSDUNIT | Ingredient unit |
| DSDCAT | Ingredient category |
| DSDBLFLG | Blend flag |
| Variable Name | Label |
|---|---|
| DSDINGID | Ingredient ID number |
| DSDINGR | Ingredient name |
| DSDBCID | Blend component ID number |
| DSDBCNAM | Blend component name |
| DSDBCCAT | Blend component category |
Source of product information
The best source of product information is the label itself, but when this cannot be obtained, other sources are used. Information from other sources may not always be an accurate reflection of what is actually on the supplement label. This is true for the supplement’s apparent name as well as for the ingredients. The apparent name on the container is most important, since interviewers see the supplement container and record the name as it appears to them. Differences from what appears on the label are particularly noted for information from the Internet (name and ingredients), the PDR (name), and supplement carton (name). In addition, supplements may change the appearance of a label and thus the apparent name without changing the content or may change content with minimal change to the label, or may change both. NCHS attempts to obtain updated labels as they come onto the market, but cannot guarantee complete success. The source of the supplement information is included in the data release.
New for the dietary supplement 2007-2008 public release
In the past the NHANES-DSD has been released in 2-year cycles. For the 2007-2008 public release and for the future releases, one NHANES-DSD with be released. This database will contain all products reported by NHANES participants since 1999. The 2007-2008 release contains products reported from 1999-2008 and the file names end in E (i.e. DSQ3_E). The 2009-2010 future release will include new products appended to the files and the file names will reflect the 2009-2010 naming system (i.e. DSQ3_F). Analyst should use the last revised version available indicated by the last letter of the file.
Using self-reported data
NHANES data are self-reported and recorded by interviewers, and thus may contain inconsistencies or errors. Some inconsistencies were edited, however, users may notice situations that still need editing. Users are advised to assess the data and edit it as deemed appropriate for the analyses being undertaken.