This example shows how to use the RELREC dataset to relate records stored in separate domains for subject 123456 who had a clinical sign (rows 1 and 4) that was related to 2 palpable masses (rows 2 and 3) and two microscopic findings (rows 5 and 6).
Row
STUDYID
RDOMAIN
USUBJID
IDVAR
IDVARVAL
RELTYPE
RELID
1
EFC1234
CL
123456
CLSEQ
5
1
2
EFC1234
PM
123456
PMSEQ
11
1
3
EFC1234
PM
123456
PMSEQ
12
1
4
EFC1234
CL
123456
CLSEQ
5
2
5
EFC1234
MI
123456
MISEQ
47
2
6
EFC1234
MI
123456
MISEQ
48
2