Page History
The Related Records (RELREC) special-purpose dataset
Jira | ||||||||
---|---|---|---|---|---|---|---|---|
|
Relationships represented in RELREC are collected relationships. The RELREC dataset should be used to represent either:
- Explicit explicit relationships, (e.g., concomitant medications taken as a result of an adverse event) ; or
- Information information of a nature that necessitates using multiple datasets and that may need to be examined together for analysis or proper interpretation.
...
Relationships between records for a subject in different datasets are specified using the key variables STUDYID, RDOMAIN, and USUBJID, along with IDVAR and IDVARVAL (the value of the identifying variable). IDVARVAL will contain the value of the variable described in IDVAR. Single records can be related by using a unique-record-identifier variable such as --SEQ in IDVAR. Groups of records can be related by using grouping variables such as --GRPID LNKID or --LNKGRP in IDVAR.
Jira | ||||||||
---|---|---|---|---|---|---|---|---|
|
...
Relationships between datasets are represented using a single record for each related dataset that identifies the key(s) of the dataset that can be used to relate the respective records. Relationships between datasets are specified using the key variables STUDYID, RDOMAIN, and IDVAR only. The values of variables USUBJID and IDVARVAL will be null as relationships between specific subject records will not be identified. The variable RELTYPE will identify the type of relationship between the datasets (e.g., a one-to-one or parent-child relationship). The allowable values for RELYPE are RELTYPE are ONE and MANY per CDISC Controlled Terminology. This information defines how a merge/join would be written, and what would be the result of the merge/join. The possible combinations are:
...
Metadataspec | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
|
Pagenav |
---|