Only some records in PC used to calculate some parameters: Time points 8 and 9 on day 1 were not used for half-life calculations, but were used for other parameters.

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 all time points on Day 1 (PCGRPID = DY1_DRGX_A and DY1_DRGX_B) were used to calculate all parameters (PPGRPID = DY1DRGX_A) except half-lives.

RELID 2

Indicates only the values for PCGRPID = DY1_DRGX_A were used to calculate the half-lives (PPGRPID = DY1DRGX_HALF).

$titleHtml

relrec.xpt

Row

STUDYID

RDOMAIN

USUBJID

IDVAR

IDVARVAL

RELTYPE

RELID

1

ABC-123

PC

ABC-123-0001

PCGRPID

DY1_DRGX_A


1

2

ABC-123

PC

ABC-123-0001

PCGRPID

DY1_DRGX_B


1

3

ABC-123

PP

ABC-123-0001

PPGRPID

DY1DRGX_A


1

4

ABC-123

PC

ABC-123-0001

PCGRPID

DY1_DRGX_A


2

5

ABC-123

PP

ABC-123-0001

PPGRPID

DY1DRGX_HALF


2

$warningHtml

Method B (One to many, using PCSEQ and PPGRPID)

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

RELID 1

Indicates records with PCSEQ values of 1-12 are related to records with PPGRPID = DY1DRGX_A

RELID 2

Indicates records with PCSEQ values of 1-7 and 10-12 are related to records with PPGRPID = DY1DRGX_HALF.

$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

5


1

6

ABC-123

PC

ABC-123-0001

PCSEQ

6


1

7

ABC-123

PC

ABC-123-0001

PCSEQ

7


1

8

ABC-123

PC

ABC-123-0001

PCSEQ

8


1

9

ABC-123

PC

ABC-123-0001

PCSEQ

9


1

10

ABC-123

PC

ABC-123-0001

PCSEQ

10


1

11

ABC-123

PC

ABC-123-0001

PCSEQ

11


1

12

ABC-123

PC

ABC-123-0001

PCSEQ

12


1

13

ABC-123

PP

ABC-123-0001

PPGRPID

DY1DRGX_A


1

14

ABC-123

PC

ABC-123-0001

PCSEQ

1


2

15

ABC-123

PC

ABC-123-0001

PCSEQ

2


2

16

ABC-123

PC

ABC-123-0001

PCSEQ

3


2

17

ABC-123

PC

ABC-123-0001

PCSEQ

4


2

18

ABC-123

PC

ABC-123-0001

PCSEQ

5


2

19

ABC-123

PC

ABC-123-0001

PCSEQ

6


2

20

ABC-123

PC

ABC-123-0001

PCSEQ

7


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

PPGRPID

DY1DRGX_HALF


2

$warningHtml

Method C (Many to one, using PCGRPID and PPSEQ)

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

RELID 1

Indicates records with a PCGRPID value of DY1_DRGX_A and DY1_DRGX_B are related to records with PPSEQ values of 1-7.

RELID 2

Indicates records with a PCGRPID value of DY1_DRGX_A are related to records with PPSEQ values of 4 and 5.

$titleHtml

relrec.xpt

Row

STUDYID

RDOMAIN

USUBJID

IDVAR

IDVARVAL

RELTYPE

RELID

1

ABC-123

PC

ABC-123-0001

PCGRPID

DY1_DRGX_A


1

2

ABC-123

PC

ABC-123-0001

PCGRPID

DY1_DRGX_B


1

3

ABC-123

PP

ABC-123-0001

PPSEQ

1


1

4

ABC-123

PP

ABC-123-0001

PPSEQ

2


1

5

ABC-123

PP

ABC-123-0001

PPSEQ

3


1

6

ABC-123

PP

ABC-123-0001

PPSEQ

6


1

7

ABC-123

PP

ABC-123-0001

PPSEQ

7


1

8

ABC-123

PC

ABC-123-0001

PCGRPID

DY1_DRGX_A


2

9

ABC-123

PP

ABC-123-0001

PPSEQ

4


2

10

ABC-123

PP

ABC-123-0001

PPSEQ

5


2

$warningHtml

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-12 are related to records with PPSEQ values of 1-7.

RELID 2

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

$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

5


1

6

ABC-123

PC

ABC-123-0001

PCSEQ

6


1

7

ABC-123

PC

ABC-123-0001

PCSEQ

7


1

8

ABC-123

PC

ABC-123-0001

PCSEQ

8


1

9

ABC-123

PC

ABC-123-0001

PCSEQ

9


1

10

ABC-123

PC

ABC-123-0001

PCSEQ

10


1

11

ABC-123

PC

ABC-123-0001

PCSEQ

11


1

12

ABC-123

PC

ABC-123-0001

PCSEQ

12


1

13

ABC-123

PP

ABC-123-0001

PPSEQ

1


1

14

ABC-123

PP

ABC-123-0001

PPSEQ

2


1

15

ABC-123

PP

ABC-123-0001

PPSEQ

3


1

16

ABC-123

PP

ABC-123-0001

PPSEQ

6


1

17

ABC-123

PP

ABC-123-0001

PPSEQ

7


1

18

ABC-123

PC

ABC-123-0001

PCSEQ

1


2

19

ABC-123

PC

ABC-123-0001

PCSEQ

2


2

20

ABC-123

PC

ABC-123-0001

PCSEQ

3


2

21

ABC-123

PC

ABC-123-0001

PCSEQ

4


2

22

ABC-123

PC

ABC-123-0001

PCSEQ

5


2

23

ABC-123

PC

ABC-123-0001

PCSEQ

6


2

24

ABC-123

PC

ABC-123-0001

PCSEQ

7


2

25

ABC-123

PC

ABC-123-0001

PCSEQ

10


2

26

ABC-123

PC

ABC-123-0001

PCSEQ

11


2

27

ABC-123

PC

ABC-123-0001

PCSEQ

12


2

28

ABC-123

PP

ABC-123-0001

PPSEQ

4


2

29

ABC-123

PP

ABC-123-0001

PPSEQ

5


2

$warningHtml