Skip to main content

"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 and product code crosswalk files below to address this. The files are based on data from January 8, 2007 through June 2, 2012. Earlier deliveries aren't included because the labeler code variable has spaces. A constructed variable indicating the type of NDC: 4-4-2, 5-3-2, or 5-4-1 is included.

An NDC to labeler code, product code, and package size crosswalk based upon CMS' Medicaid State Drug Utiization data for 1991 on is also available.

Source

Stata

SAS

CSV

Description

html dta sas7bdat csv desc

Updates and changes.

Contact data@nber.org with questions, comments, or suggestions.

Related

Topics

Data Categories

More from NBER

In addition to working papers, the NBER disseminates affiliates’ latest findings through a range of free periodicals — the NBER Reporter, the NBER Digest, the Bulletin on Retirement and Disability, the Bulletin on Health, and the Bulletin on Entrepreneurship — as well as online conference reports, video lectures, and interviews.

2024, 16th Annual Feldstein Lecture, Cecilia E. Rouse," Lessons for Economists from the Pandemic" cover slide
  • Feldstein Lecture
Cecilia Rouse, president of the Brookings Institution and a professor at Princeton University, who chaired the Council...
 2024 Methods Lecture, Susan Athey, "Analysis and Design of Multi-Armed Bandit Experiments and Policy Learning"
  • Methods Lectures
SlidesBackground Materials:backgroundAthey, Susan, Undral Byambadalai, Vitor Hadad, Sanath Kumar Krishnamurthy, Weiwen...