_dta: 1. by Jean Roth , jroth@nber.org , 6 Apr 2017 2. RPSRyyQq.TXT contains report sources for the event (0 or more). 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. caseid: 1. Number for identifying a FAERS case (example. 3123456). 2. A case consists of one or more versions. 3. A follow-up version (that is, the newest/latest version received by FDA) 4. will have the same CASE number as the initial/oldest version. rpsr_cod: 1. Code for the source of the report. (See table below.) 2. CODE MEANING_TEXT 3. ---- ------------ 4. FGN Foreign 5. SDY Study 6. LIT Literature 7. CSM Consumer 8. HP Health Professional 9. UF User Facility 10. CR Company Representative 11. DT Distributor 12. OTH Other 13. NOTE: The source from the latest version of a case is provided. 14. If there is more than one source, the codes will be line listed. obs: 25,007 vars: 3 6 Apr 2017 23:57 size: 275,077 (_dta has notes) ------------------------------------------------------------------------------- storage display value variable name type format label variable label ------------------------------------------------------------------------------- primaryid long %12.0g * Unique number for identifying a FAERS report caseid long %12.0g * Number for identifying a FAERS case (example. 3123456) rpsr_cod str3 %9s * Code for the source of the report * indicated variables have notes ------------------------------------------------------------------------------- Sorted by: primaryid rpsr_cod