_dta:
  1.  by Jean Roth , jroth@nber.org , 26 Mar 2015
  2.  THERyyQq.TXT contains drug therapy start dates and end dates for the reported drugs
  3.  (0 or more per drug per event).

primaryid:
  1.  Unique number for identifying a FAERS report.
  2.  This is the primary link field (primary key) between data files (example: 31234561).
  3.  This is a concatenated key of Case ID and Case Version Number.
  4.  It is the Identifier for the case sequence (version) number as reported by the manufacturer.

dsg_drug_seq:
  1.  Drug sequence number for identifying a drug for a Case.
  2.  To link to the DRUGyyQq.TXT data file, both the Case number primary key)
  3.  and the DRUG_SEQ number (secondary key) are needed.
  4.  (For an explanation of the DRUG_SEQ number, including an example,
  5.  see Section E, End Note 2, below.)
  6.  DRUG_SEQ (Drug file, Therapy file, and Indications file).
  7.  The best way to explain the DRUG_SEQ (drug sequence number) is with an example.
  8.  This will also clarify the relationship between a Case, the drug(s) reported for that Case,
  9.  and the therapy date(s) reported for the drug(s).
 10.  Consider Case 3078140 version 1, received by the FDA on 12/31/97.
 11.  The PRIMARYID for this case is 30781401.
 12.  Like any Case, it appears once (and only once) in the Demographic file:
 13.  PRIMARYID
 14.  ---
 15.  30781401
 16.  Four drugs were reported for this Case: Aricept was reported as suspect, and Estrogens, Prozac, and Synthroid as concomitant.
 17.  Primaryid 30781401 appears four times in the Drug file, with a different DRUG_SEQ for each drug:
 18.  PRIMARYID DRUG_SEQ DRUGNAME
 19.  --- -------- --------
 20.  30781401 1 Aricept
 21.  30781401 2 Estrogens
 22.  30781401 3 Prozac( Fluoxetine Hydrochloride
 23.  30781401 4 Synthroid (Levothyroxine Sodium)
 24.  Dates of therapy for Aricept were reported as "4/97 to 6/13/97", and "6/20/97 (ongoing)."
 25.  Since the drug was started, stopped, then restarted, there are two entries in the Drug Therapy file.
 26.  In such a circumstance, the two entries will have the same PRIMARYID and the same DRUG_SEQ #
 27.  (or DSG_DRUG_SEQ # as it is called in the Therapy file - see below).
 28.  No therapy dates were reported for the concomitants; therefore,
 29.  they do not appear in the Drug Therapy file, which is excerpted as follows:
 30.  PRIMARYID DSG_DRUG_SEQ # START_DT END_DT
 31.  --- ---------- -------- ------
 32.  30781401 1 199704 19970613
 33.  30781401 1 19970620
 34.  NOTE:  The Drug Seq # is no longer a unique key as was the case in LAERS QDE.
 35.  The Drug Seq # simply shows the order of the DRUGNAME within a unique case.
 36.  Additionally, the fields labeled DRUG_SEQ, INDI_DRUG_SEQ, and DSG_DRUG_SEQ in the Drug,
 37.  Indication, and Therapy files, respectively, all serve the same purpose
 38.  of linking the data elements in each individual file together
 39.  with the appropriate drug listed in the case using the PRIMARYID.

start_dt:
  1.  A date therapy was started (or re-started) for this drug.
  2.  (YYYYMMDD) – If a complete date not available, a partial date is provided.
  3.  See the NOTE on dates at the end of this section.

start_dt_num:
  1.  A date therapy was started (or re-started) for this drug.
  2.  YYYY-onlys are converted to midpoint of year: YYYY0702
  3.  YYYYMM-onlys are converted to midpoint of month: YYYYMM15

end_dt:
  1.  A date therapy was stopped for this drug. (YYYYMMDD)
  2.  If a complete date not available, a partial date will be provided.
  3.  See the NOTE on dates at the end of this section.

end_dt_num:
  1.  A date therapy was stopped for this drug. (YYYYMMDD)
  2.  YYYY-onlys are converted to midpoint of year: YYYY0702
  3.  YYYYMM-onlys are converted to midpoint of month: YYYYMM15

dur:
  1.  Numeric value of the duration (length) of therapy

dur_cod:
  1.  Unit abbreviation for duration of therapy (see table below)
  2.  CODE MEANING TEXT
  3.  ---- ------------
  4.  YR Years
  5.  MON Months
  6.  WK Weeks
  7.  DAY Days
  8.  HR Hours
  9.  MIN Minutes
 10.  SEC Seconds

  obs:       176,268                          
 vars:             8                          26 Mar 2015 15:52
 size:     5,464,308                          (_dta has notes)
-------------------------------------------------------------------------------------------------------------------------------------
              storage   display    value
variable name   type    format     label      variable label
-------------------------------------------------------------------------------------------------------------------------------------
primaryid       long    %12.0g              * Unique number for identifying a FAERS report
dsg_drug_seq    long    %12.0g              * Drug sequence number for identifying a drug for a Case
start_dt        long    %12.0g              * A date therapy was started (or re-started) for this drug
start_dt_num    float   %td                 * A date therapy was started (or re-started) for this drug
end_dt          long    %12.0g              * A date therapy was stopped for this drug. (YYYYMMDD)
end_dt_num      float   %td                 * A date therapy was stopped for this drug. (YYYYMMDD)
dur             long    %12.0g              * Numeric value of the duration (length) of therapy
dur_cod         str3    %9s                 * Unit abbreviation for duration of therapy
                                            * indicated variables have notes
-------------------------------------------------------------------------------------------------------------------------------------
Sorted by:  primaryid  dsg_drug_seq  start_dt_num  end_dt_num  dur  dur_cod