SEND Example.In vivo RELREC Domain-to-Domain

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.

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.