Dietary Supplement Database: Ingredient Information (DSII)

Data File: DSII.xpt

First Published: September, 2014

Last Revised: NA

Locator Record

Title: Dietary Supplement Database: Ingredient Information (DSII )
Contact Number: 1-866-441-NCHS
Years of Content: 1999
First Published: September, 2014
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 and in the two 24-hour dietary recall interviews.

Component Description

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 which contain information on products; Dietary Supplement Product Information(DSPI), Dietary Supplement Ingredient Information (DSII), and Dietary Supplement Blend Information(DSBI).

Dietary supplement information from the in-house NCHS Product Label Database (PLD) is publicly released in three files that make up the NHANES-DSD.  These files 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 the data files (DSPI, DSII, and DSBI).

In addition to entering labels into the PLD database, NCHS created generic and default dietary supplements and antacids, which are also maintained in the database. Generics were created in the database when we had information about a reported supplement such as the strength of all ingredients, but 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.   

Data Processing and Editing

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’ or ‘881’ if the supplement was created by NCHS as a generic or default product; otherwise the digits in positions 2-4 are coded ‘000’ or ‘001’. 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 DSBI.

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 DSBI 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 DSII are not included in this count, but the ingredients within the blend are counted (blend ingredients in file DSBI).

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 DSII are not included in this count, but the ingredients within the blend are counted (blend ingredients in file DSBI).

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 DSII are not included in this count, but the ingredients within the blend are counted (blend ingredients in file DSBI).

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 DSII are not included in this count, but the ingredients within the blend are counted (blend ingredients in file DSBI).

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 DSII are not included in this count, but the ingredients within the blend are counted (blend ingredients in file DSBI).

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 (DSPI) and the 'Ingredient Information' file (DSII) can be linked by supplement ID number (DSDSUPID) which is a unique product identifier. The 'Ingredient Information' file (DSII) and the 'Supplement Blend' file (DSBI) can then be linked by the ingredient ID number (DSDINGID).

Layout of DSQ_DSD

(DSPI): Supplement Product Information

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

 (DSII): Supplement Ingredient Information

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

 (DSBI): Supplement Blend Information

Variable Name	Label
DSDINGID	Ingredient ID number
DSDINGR	Ingredient name
DSDBCID	Blend component ID number
DSDBCNAM	Blend component name
DSDBCCAT	Blend component category

Analytic Notes

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, supplement companies 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.

Using self-reported data
NHANES data are self-reported and recorded by interviewers, and thus may contain inconsistencies or errors. Some inconsistencies have been 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.

 

References

N/A.

Codebook and Frequencies