Only some records in PC used to calculate parameters: Time point 5 was excluded from Tmax, 6 from Cmax, and 11 and 12 from AUC.

Method A (Many to many, using PCGRPID and PPGRPID)

Day 8 relationships are the same as those shown in Example 1.

RELID 1

Indicates that Tmax used records with PCGRPID values DY1DRGX_A, DY1DRGX_C, and DY1DRGX_D.

RELID 2

Indicates that Cmax used records with PCGRPID values DY1DRGX_A, DY1DRGX_B, and DY1DRGX_D.

RELID 3

Indicates that AUC used PCGRPID values DY1DRGX_A, DY1DRGX_B, and DY1DRGX_C.

RELID 4

Indicates that all other parameters (PPGRPID = OTHER) used all PC time points: PCGRPID values DY1DRGX_A, DY1DRGX_B, DY1DRGX_C, and DY1DRGX_D.

$titleHtml

relrec.xpt

Row

STUDYID

RDOMAIN

USUBJID

IDVAR

IDVARVAL

RELTYPE

RELID

1

ABC-123

PP

ABC-123-0001

PPGRPID

TMAX


1

2

ABC-123

PC

ABC-123-0001

PCGRPID

DY1DRGX_A


1

3

ABC-123

PC

ABC-123-0001

PCGRPID

DY1DRGX_C


1

4

ABC-123

PC

ABC-123-0001

PCGRPID

DY1DRGX_D


1

5

ABC-123

PP

ABC-123-0001

PPGRPID

CMAX


2

6

ABC-123

PC

ABC-123-0001

PCGRPID

DY1DRGX_A


2

7

ABC-123

PC

ABC-123-0001

PCGRPID

DY1DRGX_B


2

8

ABC-123

PC

ABC-123-0001

PCGRPID

DY1DRGX_D


2

9

ABC-123

PP

ABC-123-0001

PPGRPID

AUC


3

10

ABC-123

PC

ABC-123-0001

PCGRPID

DY1DRGX_A


3

11

ABC-123

PC

ABC-123-0001

PCGRPID

DY1DRGX_B


3

12

ABC-123

PC

ABC-123-0001

PCGRPID

DY1DRGX_C


3

13

ABC-123

PP

ABC-123-0001

PPGRPID

OTHER


4

14

ABC-123

PC

ABC-123-0001

PCGRPID

DY1DRGX_A


4

15

ABC-123

PC

ABC-123-0001

PCGRPID

DY1DRGX_B


4

16

ABC-123

PC

ABC-123-0001

PCGRPID

DY1DRGX_C


4

17

ABC-123

PC

ABC-123-0001

PCGRPID

DY1DRGX_D


4

$warningHtml
Note that in this RELREC table, the single records in rows 1, 3, 5, 7, and 9, represented by their --GRPIDs (Tmax, DY1DRGX_C, Cmax, DY1DRGX_B, AUC) could have been referenced by their SEQ values, as both identify the records sufficiently. At least 2 other hybrid approaches would have been acceptable as well: using PPSEQ and PCGRPIDs whenever possible or using PPGRPID and PCSEQ values whenever possible. Method D uses only SEQ values.

Method D (One to one, using PCSEQ and PPSEQ)

Day 8 relationships are the same as those shown in Example 1.

RELID 1

Indicates records with PCSEQ values of 1-4 and 6-12 are related to the record with a PPSEQ value of 1.

RELID 2

Indicates records with PCSEQ values of 1-5 and 7-12 are related to the record with a PPSEQ value of 2.

RELID 3

Indicates records with PCSEQ values of 1-10 are related to the record with a PPSEQ value of 3.

RELID 4

Indicates records with PCSEQ values of 1-12 are related to the records with PPSEQ values of 4-7.

$titleHtml

relrec.xpt

Row

STUDYID

RDOMAIN

USUBJID

IDVAR

IDVARVAL

RELTYPE

RELID

1

ABC-123

PC

ABC-123-0001

PCSEQ

1


1

2

ABC-123

PC

ABC-123-0001

PCSEQ

2


1

3

ABC-123

PC

ABC-123-0001

PCSEQ

3


1

4

ABC-123

PC

ABC-123-0001

PCSEQ

4


1

5

ABC-123

PC

ABC-123-0001

PCSEQ

6


1

6

ABC-123

PC

ABC-123-0001

PCSEQ

7


1

7

ABC-123

PC

ABC-123-0001

PCSEQ

8


1

8

ABC-123

PC

ABC-123-0001

PCSEQ

9


1

9

ABC-123

PC

ABC-123-0001

PCSEQ

10


1

10

ABC-123

PC

ABC-123-0001

PCSEQ

11


1

11

ABC-123

PC

ABC-123-0001

PCSEQ

12


1

12

ABC-123

PP

ABC-123-0001

PPSEQ

1


1

13

ABC-123

PC

ABC-123-0001

PCSEQ

1


2

14

ABC-123

PC

ABC-123-0001

PCSEQ

2


2

15

ABC-123

PC

ABC-123-0001

PCSEQ

3


2

16

ABC-123

PC

ABC-123-0001

PCSEQ

4


2

17

ABC-123

PC

ABC-123-0001

PCSEQ

5


2

18

ABC-123

PC

ABC-123-0001

PCSEQ

7


2

19

ABC-123

PC

ABC-123-0001

PCSEQ

8


2

20

ABC-123

PC

ABC-123-0001

PCSEQ

9


2

21

ABC-123

PC

ABC-123-0001

PCSEQ

10


2

22

ABC-123

PC

ABC-123-0001

PCSEQ

11


2

23

ABC-123

PC

ABC-123-0001

PCSEQ

12


2

24

ABC-123

PP

ABC-123-0001

PPSEQ

2


2

25

ABC-123

PC

ABC-123-0001

PCSEQ

1


3

26

ABC-123

PC

ABC-123-0001

PCSEQ

2


3

27

ABC-123

PC

ABC-123-0001

PCSEQ

3


3

28

ABC-123

PC

ABC-123-0001

PCSEQ

4


3

29

ABC-123

PC

ABC-123-0001

PCSEQ

5


3

30

ABC-123

PC

ABC-123-0001

PCSEQ

6


3

31

ABC-123

PC

ABC-123-0001

PCSEQ

7


3

32

ABC-123

PC

ABC-123-0001

PCSEQ

8


3

33

ABC-123

PC

ABC-123-0001

PCSEQ

9


3

34

ABC-123

PC

ABC-123-0001

PCSEQ

10


3

35

ABC-123

PP

ABC-123-0001

PPSEQ

3


3

36

ABC-123

PC

ABC-123-0001

PCSEQ

1


4

37

ABC-123

PC

ABC-123-0001

PCSEQ

2


4

38

ABC-123

PC

ABC-123-0001

PCSEQ

3


4

39

ABC-123

PC

ABC-123-0001

PCSEQ

4


4

40

ABC-123

PC

ABC-123-0001

PCSEQ

5


4

41

ABC-123

PC

ABC-123-0001

PCSEQ

6


4

42

ABC-123

PC

ABC-123-0001

PCSEQ

7


4

43

ABC-123

PC

ABC-123-0001

PCSEQ

8


4

44

ABC-123

PC

ABC-123-0001

PCSEQ

9


4

45

ABC-123

PC

ABC-123-0001

PCSEQ

10


4

46

ABC-123

PC

ABC-123-0001

PCSEQ

11


4

47

ABC-123

PC

ABC-123-0001

PCSEQ

12


4

48

ABC-123

PP

ABC-123-0001

PPSEQ

4


4

49

ABC-123

PP

ABC-123-0001

PPSEQ

5


4

50

ABC-123

PP

ABC-123-0001

PPSEQ

6


4

51

ABC-123

PP

ABC-123-0001

PPSEQ

7


4

$warningHtml