# Scriptathon2014 targets

This Wiki page contains the scripting targets associated with the 2014 Script-athon.

File:Scriptathon2014 targets.docx

**General Programming Notes:**

- The page margins used in this document mirror the margins required for US regulatory submissions. TFL fits within 9.25” x 6” common text area.
- This document contains generic titles and footnotes to aid review.
- Titles must be centered.
- Footnotes must be left justified
- Placeholders for the program, output, date generated, and source data footnotes do not need to be displayed for each shell but will be produced for each TFL consistent with the standard macro output.
- P-values should follow the formats below (these guidelines align with medical journal requirements):
- For p > 0.1, report the p-value to 2 decimal places
- For 0.1 > p > 0.001, report the p-value to 3 decimal places
- For p < 0.001, report p < 0.001.
- Decimal places for continous data summaries should follow these guidelines:
- The mean and estimates of precision (eg, variance, SD, SE, Confidence Intervals) should be displayed to 1 more decimal place than the collected data as should distributional parameters (eg, Q1, Q3) except the Minimum and Maximum which are to presented to the same decimal places as the collected data.
- Percentages are to be displayed to at least one decimal place.
- All tables summarising baseline data must include a “total” column for studies with more than 1 arm.

**White Paper of Central Tendency**

**Target 01**

*Annotations*

(assuming plot of diastolic blood pressure after lying down for 5 minutes over time for subjects in safety population)

Dataset: ADVS

Variables: USUBJID, TRTP, TRTPN, PARAM, PARAMCD, SAFFL, CHG, ATPTN, AVAL, ANL01FL, AVISIT, AVISITN

Record Selection: WHERE PARAMCD=’DIABP’ and ATPTN=815 and ANL01FL=’Y’ and . < AVISITN < 99 and SAFFL=’Y’

Boxplot of AVAL by AVISITN and TRTPN. Footnotes:

- Box plot type=schematic, the box shows median, interquartile range (IQR, edge of the bar), min and max
- within 1.5 IQR below 25% and above 75% (ends of the whisker). Values outside the 1.5 IQR below 25% and
- above 75% are shown as outliers. Means plotted as different symbols by treatments

**Target 02**

*Annotations*

(assuming plot of change from baseline in diastolic blood pressure after lying down for 5 minutes over time for subjects in safety population)

Dataset: ADVS

Variables: USUBJID, TRTP, TRTPN, PARAM, PARAMCD, CHG, ANL01FL, AVISIT, AVISITN

Record Selection: WHERE PARAMCD=’DIABP’ and ATPTN=815 and ANL01FL=’Y’ and . < AVISITN < 99 and SAFFL=’Y’

Boxplot of CHG by AVISITN and TRTPN. Footnotes:

- Endpoint=last post-baseline measure; Box plot type=schematic; The box shows median, interquartile range (IQR, edge of the bar), min and max within 1.5 IQR below
- 25% and above 75% (ends of the whisker). Values outside the 1.5 IQR below 25% and above 75% are shown as outliers. Means plotted as different symbols by treatments.
- P value is for the treatment comparison from ANCOVA model Change=Baseline+Treatment

**Target 03**

*Annotations *
(assuming plot of observed values and change from baseline in diastolic blood pressure after lying down for 5 minutes over time for subjects in safety population)

Dataset: ADVS

Variables: USUBJID, TRTP, TRTPN, PARAM, PARAMCD, AVAL, CHG, ANL01FL, AVISIT, AVISITN

Record Selection: WHERE PARAMCD=’DIABP’ and ATPTN=815 and ANL01FL=’Y’ and . < AVISITN < 99 and SAFFL=’Y’

Boxplot of AVAL and CHG by AVISITN and TRTPN. See plot footnote for boxplot details.

**Target 04**

*Annotations *
(assuming plot of mean diastolic blood pressure after lying down for 5 minutes over time for subjects in safety population)

Dataset: ADVS

Variables: USUBJID, TRTP, TRTPN, PARAM, PARAMCD, AVAL, ANL01FL, AVISIT, AVISITN

Record Selection: WHERE PARAMCD=’DIABP’ and ATPTN=815 and ANL01FL=’Y’ and . < AVISITN < 99 and SAFFL=’Y’

Plot mean of AVAL by AVISITN and TRTPN. Offset points with TRTPN=81 by subtracting 0.05 from AVISITN. High-low values come from minimum and maximum AVAL at each AVISITN.

At risk subjects = subjects with a non-missing diastolic BP value at that visit.

**Target 05**

*Annotations *
(assuming plot of diastolic blood pressure after lying down for 5 minutes over time for subjects in safety population)

Dataset: ADVS

Variables: STUDYID, USUBJID, TRTP, TRTPN, PARAM, PARAMCD, AVAL, BASE, ANL01FL, AVISIT, AVISITN

Record Selection: WHERE PARAMCD=’DIABP’ and ATPTN=815 and ANL01FL=’Y’ and AVISITN=99 and SAFFL=’Y’

Select the last post-baseline record (AVISITN=99), and plot AVAL and BASE from that record. See plot footnote for boxplot details.

**Target 06**

*Annotations *
(assuming plot of diastolic blood pressure after lying down for 5 minutes over time for subjects in safety population)

*Boxplot of change from last baseline to last post-baseline measure by STUDYID and TRTPN*

Dataset: ADVS

Variables: STUDYID, USUBJID, TRTP, TRTPN, PARAM, PARAMCD, CHG, ANL01FL, AVISIT, AVISITN

Record Selection: WHERE PARAMCD=’DIABP’ and ATPTN=815 and ANL01FL=’Y’ and AVISITN=99 and SAFFL=’Y’

*Boxplot of change from minimum baseline to minimum post-baseline records by STUDYID and TRTPN*

Dataset: ADVSMIN

Variables: STUDYID, USUBJID, TRTP, TRTPN, PARAM, PARAMCD, CHG, ANL01FL, AVISIT, AVISITN

Record Selection: WHERE PARAMCD=’DIABP’ and ATPTN=815 and ANL01FL=’Y’ and ADY > 1 and SAFFL=’Y’

*Boxplot of change from maximum baseline to minimum post-baseline records by STUDYID and TRTPN*

Dataset: ADVSMAX

Variables: STUDYID, USUBJID, TRTP, TRTPN, PARAM, PARAMCD, CHG, ANL01FL, AVISIT, AVISITN

Record Selection: WHERE PARAMCD=’DIABP’ and ATPTN=815 and ANL01FL=’Y’ and ADY > 1 and SAFFL=’Y’

See plot footnote for boxplot details.

**Target 07**

*Annotations *
(assuming plot of diastolic blood pressure after lying down for 5 minutes over time for subjects in safety population)

*Boxplot of change from last baseline to last post-baseline measure by STUDYID and TRTPN*

Dataset: ADVS

Variables: STUDYID, USUBJID, TRTP, TRTPN, PARAM, PARAMCD, AVAL, CHG, ANL01FL, AVISIT, AVISITN

Record Selection: WHERE PARAMCD=’DIABP’ and ATPTN=815 and ANL01FL=’Y’ and AVISITN=99 and SAFFL=’Y’

Plot BASE and AVAL in the observed value section, and CHG in the Changes from Baseline section.

*Boxplot of change from minimum baseline to minimum post-baseline records by STUDYID and TRTPN*

Dataset: ADVSMIN

Variables: STUDYID, USUBJID, TRTP, TRTPN, PARAM, PARAMCD, AVAL, CHG, ANL01FL, AVISIT, AVISITN

Record Selection: WHERE PARAMCD=’DIABP’ and ATPTN=815 and ANL01FL=’Y’ and ADY > 1 and SAFFL=’Y’

Plot BASE and AVAL in the observed value section, and CHG in the Changes from Baseline section.

*Boxplot of change from maximum baseline to minimum post-baseline records by STUDYID and TRTPN*

Dataset: ADVSMAX

Variables: STUDYID, USUBJID, TRTP, TRTPN, PARAM, PARAMCD, AVAL, CHG, ANL01FL, AVISIT, AVISITN

Record Selection: WHERE PARAMCD=’DIABP’ and ATPTN=815 and ANL01FL=’Y’ and ADY > 1 and SAFFL=’Y’

Plot BASE and AVAL in the observed value section, and CHG in the Changes from Baseline section.

See plot footnote for boxplot details.

**White Paper of Demographics**

**Target 08**

*Annotations *
(Country is not available within sample datasets)

Dataset: ADSL

Variables: USUBJID, TRT01P, SEX, AGE, RACE, ETHNIC, WEIGHTBL

Record Selection: WHERE ITTFL=’Y’

**White Paper of White Paper on Non-Compartmental PK**

**Target 09**

*Annotations *

<None>

**Target 10**

*Annotations *

<None>

**Target 11**

*Annotations *

<None>

**Target 12**

*Annotations *

<None>

**Target 13**

*Annotations *

<None>

**Target 14**

*Annotations *

<None>

**Target 15**

*Annotations *

<None>

**White Paper on Outliers and Shifts**

**Target 16**

*Annotations *
(assuming plot and table of diastolic blood pressure after lying down for 5 minutes over time for subjects in safety population)

Dataset: ADVSMAX

Variables: USUBJID, TRTP, TRTPN, PARAM, PARAMCD, AVAL, ANL01FL, BNRIND, ANRIND, SHIFT1, CRIT1FL

Record Selection: WHERE PARAMCD=’DIABP’ and ATPTN=815 and ANL01FL=’Y’ and ADY > 1 and SAFFL=’Y’

*Scatterplot:*

Plot BASE vs AVAL for subjects with non-missing values for both variables. Use ANRLO and ANRHI for LLN and ULN reference lines.

*Shift Table:*

N = count of subjects in the dataset for the parameter and treatment group.

Max baseline result category: BNRIND. Max post-baseline result category: ANRIND.

n = count of subjects with each combination of BNRIND and ANRIND (SHIFT1 could also be used).

Percentage = 100 * n / N.

*Treatment Emergent High Table:*

Further subset to records where CRIT1FL is not missing.

Nx = count of subjects in the resulting dataset for the parameter and treatment group.

n = count of subjects with CRIT1FL='Y'.

Percentage = 100 * n / Nx.

**Target 17**

*Annotations *
(assuming table of diastolic blood pressure after lying down for 5 minutes over time for subjects in safety population)

Dataset: ADVS

Variables: USUBJID, TRTP, TRTPN, PARAM, PARAMCD, AVAL, ANL01FL, CRIT1FL, CRIT2FL

Record Selection: WHERE PARAMCD=’DIABP’ and ATPTN=815 and ANL01FL=’Y’ and ADY > 1 and SAFFL=’Y’ and (not missing(CRIT1FL) or not missing(CRIT2FL))

Abnormal = CRIT1FL='Y' or CRIT2FL='Y'.

N = count of subjects in the resulting dataset for the parameter and treatment group.

n = count of subjects with CRIT1FL='Y' or CRIT2FL='Y'.

Percentage = 100 * n / N.

p-value from Fisher's exact test.

**Target 18**

*Annotations *
(assuming plot and table of diastolic blood pressure after lying down for 5 minutes over time for subjects in safety population)

Dataset: ADVSMAX

Variables: STUDYID, USUBJID, TRTP, TRTPN, PARAM, PARAMCD, AVAL, ANL01FL, BNRIND, ANRIND, SHIFT1, CRIT1FL

Record Selection: WHERE PARAMCD=’DIABP’ and ATPTN=815 and ANL01FL=’Y’ and ADY > 1 and SAFFL=’Y’

*Scatterplot:*

Plot BASE vs AVAL by STUDYID for subjects with non-missing values for both variables. Use ANRLO and ANRHI for LLN and ULN reference lines.

*Treatment Emergent High Table:*

Further subset to records where CRIT1FL is not missing.

N = count of subjects in the resulting dataset for the parameter and treatment group.

n = count of subjects with CRIT1FL='Y'.

Percentage = 100 * n / N.

**Target 19**

*Annotations *
(assuming table of diastolic blood pressure after lying down for 5 minutes over time for subjects in safety population)

Dataset: ADVS

Variables: STUDYID, USUBJID, TRTP, TRTPN, PARAM, PARAMCD, AVAL, ANL01FL, CRIT1FL, CRIT2FL

Record Selection: WHERE PARAMCD=’DIABP’ and ATPTN=815 and ANL01FL=’Y’ and ADY > 1 and SAFFL=’Y’ and (not missing(CRIT1FL) or not missing(CRIT2FL))

Abnormal = CRIT1FL='Y' or CRIT2FL='Y'.

N = count of subjects in the resulting dataset for the parameter and treatment group.

n = count of subjects with CRIT1FL='Y' or CRIT2FL='Y'.

Percentage = 100 * n / N.

Odds ratio:

Heterogeneity p-value:

p-value:

**Target 20**

*Annotations *
(assuming plot and table of diastolic blood pressure after lying down for 5 minutes over time for subjects in safety population)

Dataset: ADVS

Variables: USUBJID, TRTP, TRTPN, PARAM, PARAMCD, AVAL, ANL01FL, AVISIT, AVISITN, CRIT1FL

Record Selection: WHERE PARAMCD=’DIABP’ and ATPTN=815 and ANL01FL=’Y’ and . < AVISITN < 99 and SAFFL=’Y’

*Boxplot:*

Plot AVAL by AVISITN and TRTPN. See plot footnote for boxplot details.

*Treatment Emergent High Table:*

Further subset to records where CRIT1FL is not missing.

N = count of subjects in the resulting dataset for the parameter and treatment group.

n = count of subjects with CRIT1FL='Y'.

Percentage = 100 * n / N.
p-value from Fisher's exact test.

**Target 21**

*Annotations *
(assuming table of diastolic blood pressure after lying down for 5 minutes over time for subjects in safety population)

Dataset: ADVS

Variables: USUBJID, TRTP, TRTPN, PARAM, PARAMCD, AVAL, CRIT1, CRIT1FL, , CRIT2, CRIT2FL

Record Selection: WHERE PARAMCD=’DIABP’ and ATPTN=815 and ADY > 1 and SAFFL=’Y’ and (not missing(CRIT1FL) or not missing(CRIT2FL))

*Abnormality Direction: Low*

N = number of subjects with at least 1 record with non-missing CRIT2FL.

n = number of subjects with CRIT2FL='Y'.

*Abnormality Direction: High*

N = number of subjects with at least 1 record with non-missing CRIT1FL.

n = number of subjects with CRIT1FL='Y'.

Percentage = 100 * n / N.

**Target 22**

*Annotations *
(assuming table of diastolic blood pressure after lying down for 5 minutes over time for subjects in safety population)

Dataset: ADVS

Variables: USUBJID, TRTP, TRTPN, PARAM, PARAMCD, AVAL, ANL01FL, BNRIND, ANRIND, SHIFT1, CHGCAT1

Record Selection: WHERE PARAMCD=’DIABP’ and ATPTN=815 and ANL01FL=’Y’ and AVISITN=99 and SAFFL=’Y’ and BNRIND ne 'Missing' and ANRIND ne 'Missing'

*Shift Table:*

N = count of subjects in the dataset for the parameter and treatment group.

Baseline result category: BNRIND. Post-baseline result category: ANRIND.

n = count of subjects with each combination of BNRIND and ANRIND (SHIFT1 could also be used).

Percentage = 100 * n / N.

*Change Summary:*

N = count of subjects in the dataset for the parameter and treatment group.

n = count of subjects with specified CHGCAT1 value.

pvalue:

**White Paper of Hepatotoxicity**

**Target 23**

*Annotations *

Dataset: ADLBHY

Variables: USUBJID, TRTP, TRTPN, PARAM, PARAMCD, R2A1HI

Record Selection: WHERE PARAMCD in ('ALT', 'BILI') and ANL01FL=’Y’ and SAFFL=’Y’

Plot R2A1HI for ALT on the X-axis and R2A1HI for BILI on the Y-axis. Display axes using a logarithmic scale.

**White Paper of Adverse Events**

<nothing>

**White Paper of Hepatotoxicity Measures**

<nothing>

.