Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Excerpt
This example shows how to use the RELREC dataset to represent related information that is submitted as multiple datasets that have an identifying variable in common.


In this example, all the records with the same --SPID across the domains with the same USUBJID are being related to each other. Because this relationship exists for all values of USUBJID and all values of --SPID (specified in IDVARVAL), both USUBJID and IDVARVAL are null.

Dataset wrap
Namerelrec
Dataset2
RowSTUDYIDRDOMAINUSUBJIDIDVARIDVARVALRELTYPERELID
1999123CL
CLSPID
MANYA
2999123MI
MISPID
MANYA
3999123MA
MASPID
MANYA
4999123PM
PMSPID
MANYA
5999123TF
TFSPID
MANYA

Because IDVAR identifies the keys that can be used to merge/join records between the datasets, the root values (e.g., --SPID in this example) for IDVAR are the same for all records with the same RELID. --SEQ cannot be used because --SEQ only has meaning within a subject within a domain, not across domains.