"Since the NDC is limited to 10 digits, a firm with a 5 digit labeler code must choose between a 3 digit product code and 2 digit package code, or a 4 digit product code and 1 digit package code."
"Thus, you have either a 5-4-1 or a 5-3-2 configuration for the three segments of the NDC. Because of a conflict with the HIPAA standard of an 11 digit NDC, many programs will pad the product code or package code segments of the NDC with a leading zero instead of the asterisk."
"Since a zero can be a valid digit in the NDC, this can lead to confusion when trying to reconstitute the NDC back to its FDA standard. Example: 12345-0678-09 (11 digits) could be 12345-678-09 or 12345-0678-9 depending on the firm's configuration."
The current deliveries of the FDA's NDC data include the NDC variable. However, files from June 2, 2012 and earlier contain the three segments of the NDC variable rather than the NDC variable itself.
Jean Roth created the ndc to labeler code, product code, and package size crosswalk files below to address this. The files are based on CMS' Medicaid State Drug Utilization data. Constructed variables indicating first year and last year the NDC appeared in the State Drug Utilization data are included.
An NDC to labeler code product code crosswalk based upon FDA NDC data is also available.
Source |
Stata |
SAS |
CSV |
Description |
html | dta | sas7bdat | csv | desc |
Contact data@nber.org with questions, comments, or suggestions.
Created by Jean Roth February 20, 2018