size:    24,897,080                          (_dta has notes)
---------------------------------------------------------------------------------------------------------------------------------------------------
              storage   display    value
variable name   type    format     label      variable label
---------------------------------------------------------------------------------------------------------------------------------------------------
ingredient      str233  %233s               * Ingredient
dfroute         str55   %55s                * Dosage Form; Route
doseform        str46   %46s                  Dosage Form.  (from dfroute)
route           str44   %44s                  Route of Administration.  (from dfroute)
trade_name      str88   %88s                * Trade Name (Proprietary Name)
applicant       str20   %20s                * Applicant
strength        str206  %206s               * Strength
appl_type       str1    %9s                 * Application Type
appl_no         long    %12.0g              * Application Number
product_no      byte    %8.0g               * Product Number
tecodestr       str15   %15s                  Therapeutic Equivalence (TE) Code
tecode          float   %140.0g    tecode   * Therapeutic Equivalence (TE) Code
appdatestr      str29   %29s                  Approval Date
appdate         float   %td        appdate  * Approval Date; 1982-01-01 = 'Approved Prior to Jan 1, 1982'
rld             str3    %9s                 * Reference Listed Drug
type            str5    %9s                 * Type
appfull         str87   %87s                * Applicant Full Name
                                            * indicated variables have notes
---------------------------------------------------------------------------------------------------------------------------------------------------
Sorted by:  ingredient  dfroute  doseform  route  trade_name  applicant  strength  appl_type  appl_no  product_no  tecodestr  tecode  appdatestr  a
> ppdate  rld  type  appfull

_dta:
  1.  by Jean Roth , jroth@nber.org , 30 Sep 2014

ingredient:
  1.  The active ingredient(s) for the product.
  2.  Multiple ingredients are in alphabetical order, separated by a semicolon.

dfroute:
  1.  Dosage form;Route of Administration
  2.  The product dosage form and route separated by a semi-colon. The format is not all uppercase.

trade_name:
  1.  The trade name of the product as shown on the labeling.

applicant:
  1.  The firm name holding legal responsibility for the new drug application.
  2.  The firm name is condensed to a maximum twenty character unique string.

strength:
  1.  The potency of the active ingredient. May repeat for multiple part products.

appl_type:
  1.  New Drug Application Type The type of new drug application approval.
  2.  New Drug Applications (NDA or innovator) are "N". Abbreviated New Drug Applications (ANDA or generic) are "A".

appl_no:
  1.  New Drug Application (NDA) Number The FDA assigned number to the application. Format is nnnnnn.

product_no:
  1.  Product Number. The FDA assigned number to identify the application products.
  2.  Each strength is a separate product. May repeat for multiple part products. Format is nnn.

tecode:
  1.  Therapeutic Equivalence (TE) Code
  2.  The TE Code indicates the therapeutic equivalence rating of generic to innovator Rx products.

appdate:
  1.  Approval Date. The date the product was approved as stated in the FDA approval letter to the applicant.
  2.  The format is Mmm dd, yyyy.
  3.  Products approved prior to the January 1, 1982 contain the phrase: "Approved prior to Jan 1, 1982".

rld:
  1.  Reference Listed Drug (RLD). The pioneer or innovator of the drug.
  2.  The RLD identifies the product Abbreviated New Drug Applications (ANDA) use as a reference. Format is Yes or No.

type:
  1.  The group or category of approved drugs. Format is RX, OTC, DISCN.

appfull: