_dta: 1. by Jean Roth , jroth@nber.org , 19 Nov 2015 2. Source: 2011/20111020/listings.TXT 3. File description: http://www.fda.gov/Drugs/InformationOnDrugs/ucm257245.htm 4. EACH PRODUCT HAS A UNIQUE LISTING SEQ NO; EACH FIRM SEQ NO CAN HAVE MULTIPLE LISTING SEQ NO'S. 5. Each line in this file represents a product for an individual firm. 6. The listing includes such information as the product's name, firm's seq number, dose form(s), and Rx/OTC. listing_seq_no: 1. LISTING_SEQ_NO NOT NULL NUM(7) COL: 1-7 2. FDA generated unique identification number for each product. lblcode: 1. LBLCODE NOT NULL CHAR(6) COL: 9-14 2. Labeler code portion of NDC; assigned by FDA to firm. 3. The labeler code is the first segment of the National Drug Code. 4. While always displayed as 6 digits in this file; for labeler codes 2 through 9999, some systems display it as 4 digits; 5. for labeler codes 10,000 through 99,999 it is 5 digits. Can be used to link to the FIRMS.TXT file to obtain firm name. prodcode: 1. PRODCODE NOT NULL CHAR(4) COL: 16-19 2. Product code assigned by firm. 3. The prodcode is the second segment of the National Drug Code. 4. It may be a 3-digit or 4-digit code depending upon the NDC configuration selected by the firm. strength: 1. STRENGTH NULL CHAR(10) COL: 21-30 2. For single entity products, this is the potency of the active ingredient. 3. For combination products, it may be null or a number or combination of numbers, e.g., Inderide 40/25. unit: 1. UNIT NULL CHAR(10) COL: 32-41 2. Unit of measure corresponding to strength. 3. This non-mandatory field contains the unit code for a single entity product, e.g., MG, %VV. rx_otc: 1. RX_OTC NOT NULL CHAR(1) COL: 43 2. Indicates whether product is labeled for Rx or OTC use (R/O). tradename: 1. TRADENAME NOT NULL CHAR(100) COL: 45-144 2. Product's name as it appears on the labeling. obs: 75,072 vars: 7 19 Nov 2015 07:56 size: 10,134,720 (_dta has notes) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- storage display value variable name type format label variable label ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- listing_seq_no long %12.0g * FDA generated unique identification number for each product lblcode str6 %9s * Labeler code portion of NDC; assigned by FDA to firm prodcode str4 %9s * Product code assigned by firm strength str10 %10s * For single entity products, this is the potency of the active ingredient unit str10 %10s * Unit of measure corresponding to strength rx_otc str1 %9s * Indicates whether product is labeled for Rx or OTC use (R/O) tradename str100 %100s * Product's name as it appears on the labeling * indicated variables have notes ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Sorted by: listing_seq_no