Tutorials › Biostatistics › Efficacy Table Development for Clinical Study Reports

Clinical Reporting & Biostatistics

Efficacy Table Development for Clinical Study Reports

A practical guide to designing, deriving, reviewing, and QC'ing efficacy tables for Clinical Study Reports, including endpoint definitions, analysis populations, denominators, descriptive statistics, treatment comparisons, confidence intervals, missing data, subgroup analyses, and traceability back to the analysis datasets.

Advanced 20 min read

What You'll Learn

  • How efficacy tables fit into the Clinical Study Report
  • How to translate protocol and SAP endpoints into table shells
  • How denominators and analysis populations determine the correct results
  • How to present continuous, binary, time-to-event, and responder endpoints
  • How treatment effects, confidence intervals, and p-values should be displayed
  • How to perform programming, reconciliation, and final-table QC

Introduction

Efficacy tables are among the most important statistical outputs in a Clinical Study Report (CSR). They transform the statistical analysis described in the Statistical Analysis Plan into a compact presentation of the evidence supporting the study's efficacy conclusions.

A good efficacy table is more than a formatted collection of numbers. Every number should have a defined endpoint, analysis population, treatment group, denominator, analysis method, and source in the underlying analysis datasets.

Key idea: A CSR efficacy table should be treated as a statistical reporting product, not merely as a formatting exercise. The table must faithfully implement the protocol, SAP, analysis datasets, and prespecified estimands.

Where Efficacy Tables Fit in the CSR

A typical CSR contains several layers of efficacy evidence. The tables should tell a coherent statistical story from the primary endpoint through secondary and supportive analyses.

CSR Component Typical Purpose
Primary efficacy table Provides the prespecified analysis of the primary endpoint and treatment effect.
Secondary efficacy tables Summarize key secondary endpoints defined in the protocol and SAP.
Other efficacy tables Present exploratory or supportive efficacy endpoints.
Responder analyses Show proportions of patients meeting clinically meaningful response criteria.
Subgroup analyses Evaluate consistency of treatment effects across prespecified subgroups.
Sensitivity analyses Assess robustness of the primary or key secondary conclusions.

The Core Principle: Start With the SAP

The first step in efficacy-table development is not programming. It is understanding exactly what the SAP requires.

For each efficacy endpoint, identify:

  • the endpoint definition;
  • the analysis time point or assessment window;
  • the analysis population;
  • the statistical method;
  • the treatment effect measure;
  • the missing-data strategy;
  • the handling of intercurrent events;
  • the multiplicity strategy, if applicable;
  • the confidence interval level;
  • the rounding and presentation conventions.
Do not design the table from the data alone. If the programmer begins with the dataset and decides what appears statistically interesting, the resulting table may no longer represent the prespecified analysis. The SAP should drive the table specification.

The Efficacy Table Shell

Before results are available, statisticians commonly develop a table shell. The shell specifies the structure, labels, statistical summaries, footnotes, and treatment columns without inserting actual study results.

For example, a continuous primary endpoint might use the following structure:

Analysis Treatment A
(N = 150)
Treatment B
(N = 148)
Difference
(95% CI)
p-value
Baseline, Mean (SD) 42.3 (8.1) 41.9 (7.8) — —
Week 24, Mean (SE) 31.4 (1.0) 36.8 (1.1) -5.4 (-8.2, -2.6) 0.0003
Change from Baseline, LS Mean (SE) -10.8 (0.9) -5.3 (0.9) -5.5 (-8.0, -3.0) <0.0001

Illustrative values only. Actual CSR values must be generated from the prespecified analysis datasets and statistical methods.

Step 1: Define the Analysis Population

The same efficacy endpoint can produce different results depending on the analysis population.

Common populations include:

  • Intent-to-Treat (ITT) population: generally based on treatment assignment or randomization.
  • Full Analysis Set (FAS): defined according to the protocol and SAP.
  • Per-Protocol (PP) population: subjects satisfying prespecified protocol-adherence criteria.
  • Safety population: generally used for safety analyses rather than primary efficacy analyses.
Important: The denominator shown in an efficacy table must correspond to the population actually used for that analysis. Do not automatically use the randomized sample size for every row.

Step 2: Establish the Correct Denominator

Denominators are one of the most common sources of errors in clinical reporting.

For a binary endpoint, the observed response rate is:

$$ \widehat{p} = \frac{x}{n} $$

where \(x\) is the number of responders and \(n\) is the number of patients included in the denominator.

For example, suppose 72 of 140 evaluable patients respond:

$$ \widehat{p} = \frac{72}{140} = 0.5143 $$

or:

$$ \widehat{p}\times100\% = 51.43\% $$

If the table instead uses 150 randomized patients as the denominator, the reported rate becomes:

$$ \frac{72}{150} = 48.0\% $$

Both calculations are mathematically correct, but they answer different questions. The correct denominator is determined by the SAP-defined analysis.

Step 3: Determine the Endpoint Type

The structure of an efficacy table depends heavily on the statistical nature of the endpoint.

Endpoint Type Typical Summary Common Treatment Effect
Continuous Mean, SD, LS mean, SE Mean difference
Binary n, % Risk difference, risk ratio, odds ratio
Time-to-event Events, censored, median Hazard ratio
Count Mean, SD, median, range Rate ratio or model-based difference
Responder endpoint Responders / total, % Difference or ratio in response rates
Repeated measures LS mean by visit Treatment difference at prespecified visit

Continuous Efficacy Endpoints

For a continuous endpoint, the table may present baseline values, post-baseline values, and change from baseline.

The arithmetic change from baseline is:

$$ \Delta_i = Y_{i,\text{post}} - Y_{i,\text{baseline}} $$

A descriptive table might contain:

Parameter Drug A Placebo Treatment Difference p-value
N 150 148 — —
Baseline, Mean (SD) 82.4 (12.1) 81.7 (11.8) — —
Week 12, Mean (SD) 70.3 (15.0) 76.5 (14.4) — —
Change from Baseline, Mean (SD) -12.1 (10.8) -5.2 (10.4) -6.9 —
LS Mean Change (SE) -11.7 (0.9) -5.4 (0.9) -6.3 (-8.8, -3.8) <0.0001

Arithmetic Mean vs. Least-Squares Mean

One of the most important distinctions in efficacy reporting is the difference between a descriptive arithmetic mean and a model-based least-squares mean.

The arithmetic sample mean is:

$$ \bar{x} = \frac{1}{n} \sum_{i=1}^{n}x_i $$

A least-squares mean, or model-adjusted mean, is instead derived from the prespecified statistical model.

Reporting rule: Do not label a model-derived estimate as "Mean." If the value is an LS mean, adjusted mean, marginal mean, or model-based estimate, the table should say so explicitly.

Binary Efficacy Endpoints

For binary endpoints, the fundamental table structure is usually:

Endpoint Drug A
n/N (%)
Placebo
n/N (%)
Treatment Effect
(95% CI)
p-value
Responder 72/150 (48.0) 41/148 (27.7) 20.3 (9.5, 31.1) 0.0003

The observed response rate is:

$$ \widehat{p}_T = \frac{x_T}{n_T} $$

and the treatment difference in response rates is:

$$ \widehat{D} = \widehat{p}_T - \widehat{p}_C $$

For the illustrative values:

$$ 0.480-0.277 = 0.203 $$

or approximately:

$$ 20.3\% $$

Confidence Intervals for Binary Endpoints

The confidence interval accompanying a responder analysis depends on the prespecified statistical method.

For a treatment difference:

$$ D=p_T-p_C $$

the table should identify the confidence interval method when appropriate, particularly when an exact or adjusted method is used.

Do not automatically calculate a Wald confidence interval. Clinical-trial reporting frequently requires methods that behave better for proportions near 0% or 100%, and the SAP should determine the method.

Time-to-Event Efficacy Endpoints

Time-to-event endpoints require a different table structure because not every patient necessarily experiences the event.

Typical information includes:

  • number of patients;
  • number of events;
  • number censored;
  • median time-to-event;
  • confidence interval for the median;
  • hazard ratio;
  • confidence interval for the hazard ratio;
  • p-value.
Analysis Drug A Placebo Hazard Ratio
(95% CI)
p-value
N 200 198 — —
Events, n (%) 92 (46.0) 118 (59.6) — —
Median, months (95% CI) 14.8 (13.1, 17.2) 10.7 (9.2, 12.6) — —
Hazard ratio — — 0.72 (0.56, 0.93) 0.011

The hazard ratio is generally interpreted as a relative comparison of the instantaneous event rates under the specified model.

Repeated-Measures Efficacy Tables

Longitudinal efficacy endpoints often require tables containing multiple assessment visits.

Visit Drug A
LS Mean (SE)
Placebo
LS Mean (SE)
Difference
(95% CI)
p-value
Baseline 48.2 (0.7) 47.9 (0.7) 0.3 (-1.7, 2.3) 0.76
Week 4 43.8 (0.8) 46.1 (0.8) -2.3 (-4.4, -0.2) 0.032
Week 8 39.6 (0.8) 44.2 (0.8) -4.6 (-6.8, -2.4) <0.0001
Week 12 36.8 (0.9) 42.9 (0.9) -6.1 (-8.5, -3.7) <0.0001
Important: A longitudinal table should make clear whether the values are observed descriptive means, LS means from a repeated-measures model, or another model-based estimate. These are not interchangeable quantities.

Change From Baseline Tables

When the primary endpoint is change from baseline, the table should clearly distinguish the baseline value from the change being analyzed.

For each patient:

$$ \Delta_i=Y_{i,t}-Y_{i,0} $$

where \(Y_{i,0}\) is the baseline measurement and \(Y_{i,t}\) is the value at the specified post-baseline time point.

The treatment effect may then be represented as:

$$ D = \mu_T-\mu_C $$

where \(\mu_T\) and \(\mu_C\) are the corresponding treatment-group estimands.

Responder Analyses

Responder analyses convert a continuous or ordinal endpoint into a binary clinical outcome.

For example, suppose a responder is defined as a reduction of at least 30 units from baseline.

Response Category Drug A Placebo Difference
(95% CI)
p-value
Responder ≥30 units 84/150 (56.0%) 55/148 (37.2%) 18.8 (7.8, 29.8) 0.0008
Non-responder 66/150 (44.0%) 93/148 (62.8%) — —

The response definition must match the prespecified endpoint definition. Changing the threshold after reviewing results can introduce substantial bias.

Multiplicity and P-Value Presentation

A CSR efficacy table may contain many p-values. The presence of a p-value in a table does not automatically mean that the associated hypothesis was formally tested at the nominal significance level.

The table should distinguish among:

  • confirmatory hypothesis tests;
  • multiplicity-adjusted tests;
  • nominal p-values;
  • descriptive analyses;
  • exploratory analyses.
Never imply confirmatory significance from an unadjusted p-value when the SAP specifies multiplicity control.

If multiplicity adjustment is used, the table should clearly identify the adjusted testing procedure or indicate through a footnote how the reported p-values should be interpreted.

Missing Data and Unevaluable Patients

Missing data can affect both the numerator and denominator of efficacy analyses.

Potential reasons for missing efficacy assessments include:

  • withdrawal;
  • loss to follow-up;
  • missed visits;
  • treatment discontinuation;
  • protocol deviations;
  • technical failure of an assessment;
  • death or another intercurrent event.

The treatment of missing data should follow the SAP-defined analysis method. For example, an analysis may use a model-based missing-data assumption rather than simply classifying every missing patient as a non-responder.

Table implication: The denominator displayed in a responder table should not be changed merely because a programmer believes a different denominator is more intuitive. The denominator must correspond to the prespecified analysis.

Estimands and Efficacy Tables

Modern clinical-trial analyses distinguish the treatment effect being estimated from the raw endpoint measurement.

An estimand generally specifies the key components of the treatment-effect question, including:

  • the population;
  • the treatment condition;
  • the variable or endpoint;
  • the handling of intercurrent events;
  • the population-level summary measure.

This distinction matters because two analyses using the same endpoint can answer different scientific questions if they handle treatment discontinuation, rescue medication, death, or other intercurrent events differently.

Practical rule: The table title, row labels, footnotes, and statistical method should make it possible for a reviewer to understand which treatment-effect question the analysis addresses.

Subgroup Efficacy Tables

Subgroup tables evaluate whether the treatment effect appears consistent across clinically relevant categories.

Subgroup Drug A Placebo Treatment Effect
(95% CI)
Overall 0.48 0.28 0.20 (0.10, 0.31)
Age <65 years 0.51 0.30 0.21 (0.08, 0.34)
Age ≥65 years 0.44 0.25 0.19 (0.02, 0.36)
Male 0.47 0.27 0.20 (0.07, 0.33)
Female 0.50 0.28 0.22 (0.06, 0.38)
Do not interpret overlapping or non-overlapping subgroup confidence intervals as a formal interaction test. The appropriate assessment of treatment-effect heterogeneity is generally based on a prespecified treatment-by-subgroup interaction analysis.

Table Titles and Footnotes

A strong table title should tell the reader what is being analyzed without requiring them to search elsewhere in the CSR.

A useful structure is:

Table X.X.X
Summary of Primary Efficacy Endpoint at Week 24
Full Analysis Set

Footnotes should clarify important details such as:

  • analysis population;
  • statistical model;
  • covariates;
  • confidence interval method;
  • missing-data handling;
  • multiplicity adjustment;
  • rounding conventions;
  • definitions of abbreviations.

Example: Complete Primary Efficacy Table

Consider a randomized Phase III study comparing an experimental treatment with placebo. The primary endpoint is change from baseline in a continuous score at Week 24.

Primary Efficacy Endpoint Drug A
(N = 302)
Placebo
(N = 300)
Difference
(95% CI)
p-value
Baseline, Mean (SD) 68.4 (12.2) 67.9 (12.0) — —
Week 24, LS Mean (SE) 52.8 (0.9) 59.4 (0.9) -6.6 (-9.1, -4.1) <0.0001
Change From Baseline, LS Mean (SE) -15.6 (0.9) -8.5 (0.9) -7.1 (-9.6, -4.6) <0.0001

An appropriate footnote might state:

LS = least squares; SD = standard deviation;
SE = standard error; CI = confidence interval.

LS means and treatment difference are based on the prespecified
analysis model. The model includes treatment and prespecified
baseline covariates. The 95% CI is two-sided.

Analysis population: Full Analysis Set.

How to Build the Table From the Analysis Dataset

The relationship between the clinical-trial datasets and the final CSR table should be traceable.

A simplified reporting chain is:

1
Protocol: defines the clinical objective and endpoint.
2
SAP: defines the statistical analysis and presentation rules.
3
Analysis datasets: provide analysis-ready subject-level data.
4
Statistical program: derives the table statistics.
5
Output: produces the draft efficacy table.
6
QC: independently verifies calculations, populations, labels, and formatting.
7
CSR: incorporates the validated table and corresponding narrative.

Table Programming Specifications

Before programming begins, the statistician should provide a sufficiently detailed table specification.

Specification Element Example
Table number 14.2.1
Endpoint Change from baseline in primary score at Week 24
Population Full Analysis Set
Treatment variable Randomized treatment
Analysis method Prespecified ANCOVA / repeated-measures model
Effect measure LS mean treatment difference
Confidence interval Two-sided 95%
Missing data Per SAP-defined method
Rounding Means: 1 decimal; p-values: 4 decimals or <0.0001
Footnotes Model, population, abbreviations, and analysis conventions

Independent QC of Efficacy Tables

A second programmer or statistician should independently verify the critical components of the table.

QC should include both statistical validation and presentation validation.

QC Area Question
Population Are the correct subjects included?
Treatment Are subjects assigned to the correct treatment group?
Endpoint Is the correct variable and time point used?
Baseline Is baseline defined according to the SAP?
Denominator Does each percentage use the correct denominator?
Model Are the correct model and covariates used?
Estimate Does the reported treatment effect match the model output?
Confidence interval Is the correct CI method and confidence level used?
p-value Is the correct hypothesis test reported?
Rounding Are displayed values rounded consistently?
Footnotes Do footnotes accurately describe the analysis?
Reconciliation Do totals reconcile with other CSR outputs?

Numerical QC Example

Suppose a responder table reports:

Group Responders Total Reported %
Drug A 72 150 48.0%
Placebo 41 148 27.7%

The QC calculation for Drug A is:

$$ \frac{72}{150}\times100\% = 48.0\% $$

For placebo:

$$ \frac{41}{148}\times100\% = 27.7027\% \approx27.7\% $$

The treatment difference is:

$$ 48.0\%-27.7\% = 20.3\% $$

The QC process should verify not only the displayed percentage but also the underlying numerator and denominator.

Cross-Table Reconciliation

A particularly important CSR QC step is comparing related outputs.

For example, the number of randomized patients in an efficacy table should reconcile with the corresponding disposition and demographic tables when the same population is intended.

A
Disposition: confirm randomized and treated populations.
B
Demographics: confirm the analysis population and treatment counts.
C
Efficacy: confirm endpoint-specific denominators.
D
CSR narrative: confirm that reported conclusions match the tables.
E
Listings: trace unexpected or influential observations back to subjects.

Common Efficacy Table Errors

  1. Using the wrong analysis population. A table may accidentally use the safety population instead of the prespecified efficacy population.
  2. Using the wrong denominator. Percentages may be calculated using randomized patients rather than the endpoint-specific denominator.
  3. Confusing observed and model-based results. Arithmetic means and LS means should not be labeled interchangeably.
  4. Reporting an incorrect time point. A Week 24 analysis should not accidentally use the closest available visit unless that is specified in the SAP.
  5. Ignoring treatment discontinuation. Intercurrent events may materially change the interpretation of an efficacy analysis.
  6. Using the wrong confidence interval. The confidence interval must correspond to the prespecified treatment-effect measure and method.
  7. Overinterpreting subgroup results. Apparent differences between subgroup estimates do not necessarily establish treatment-effect heterogeneity.
  8. Incorrect p-value adjustment. Multiplicity requirements must be reflected in the reported inferential results.
  9. Rounding too early. Intermediate calculations should generally use full precision, with rounding performed for presentation.
  10. Inconsistent footnotes. Table terminology must remain consistent with the SAP and other CSR outputs.

Rounding and Display Conventions

Rounding is part of table specification and should be standardized.

Statistic Illustrative Display
Mean 42.3
Standard deviation 8.1
Standard error 0.9
Percentage 48.0%
Hazard ratio 0.72
Confidence interval (0.56, 0.93)
p-value 0.0032
Very small p-value <0.0001
Never round intermediate values before calculating a treatment effect or confidence interval. For example, a treatment difference should generally be calculated from the underlying estimates rather than from the already-rounded values displayed in the table.

Statistical vs. Presentation QC

These are related but distinct activities.

Statistical QC Presentation QC
Correct population Correct title
Correct endpoint Correct column headings
Correct model Consistent decimal places
Correct denominator Readable table layout
Correct treatment effect Correct footnotes
Correct CI Correct abbreviations
Correct p-value No clipped or missing text

From Table to CSR Narrative

The efficacy narrative should be derived from the validated table, not independently recreated from memory or preliminary outputs.

For example, if the primary efficacy table shows:

Illustrative Primary Treatment Effect
−7.1 points (95% CI −9.6 to −4.6; p < 0.0001)

the CSR narrative should report the same estimate, confidence interval, and inferential result.

Single source of truth: The final validated statistical output should drive the CSR tables, figures, and corresponding narrative so that the same analysis is not independently recalculated in several places.

A Practical Efficacy Table Development Workflow

1
Review the protocol and identify all efficacy objectives and endpoints.
2
Review the SAP for the exact analysis population, method, estimand, and presentation requirements.
3
Create the table shell before final results are programmed.
4
Define treatment columns, analysis populations, denominators, and endpoint time points.
5
Specify descriptive statistics and treatment-effect measures.
6
Specify confidence intervals, p-values, multiplicity adjustments, and missing-data rules.
7
Program the table using the appropriate analysis datasets.
8
Perform independent statistical QC.
9
Perform presentation and formatting QC.
10
Reconcile efficacy results against related tables, listings, figures, and CSR text.
11
Resolve discrepancies and document corrections.
12
Finalize the validated table and use it as the source for the corresponding CSR narrative.

What Should Be Documented in the Table Specification?

A robust table specification should contain enough information for another qualified statistician or programmer to reproduce the output.

  • table identifier and title;
  • endpoint definition;
  • analysis population;
  • treatment variable;
  • baseline definition;
  • analysis visit or time point;
  • statistical method;
  • covariates;
  • estimand and intercurrent-event strategy, where applicable;
  • treatment-effect measure;
  • confidence interval method;
  • hypothesis-testing method;
  • multiplicity adjustment;
  • missing-data handling;
  • rounding conventions;
  • footnotes and abbreviations;
  • program and dataset traceability.

Final Efficacy Table Checklist

Check Question
✓ Does the table implement the SAP exactly?
✓ Is the correct analysis population used?
✓ Are treatment groups correct?
✓ Is the endpoint definition correct?
✓ Is the correct assessment time point used?
✓ Are all denominators correct?
✓ Are descriptive statistics correct?
✓ Is the treatment effect calculated correctly?
✓ Is the confidence interval correct?
✓ Is the p-value correct?
✓ Is multiplicity handled correctly?
✓ Are missing-data rules correctly implemented?
✓ Are footnotes accurate?
✓ Are decimal places and rounding consistent?
✓ Do related CSR tables reconcile?
✓ Does the CSR narrative agree with the final table?
✓ Can every important result be traced to the analysis dataset and program?

Key Takeaways

Efficacy-table development is fundamentally an exercise in statistical translation and traceability.

The protocol defines what the trial is trying to establish. The SAP defines how the efficacy question will be analyzed. The analysis datasets provide the data required for the analysis. The statistical program converts those data into estimates and inferential results. The efficacy table then presents those results in a form that can be independently reviewed.

The most important principles are:

  • Build from the SAP, not from the data.
  • Make analysis populations explicit.
  • Verify every denominator.
  • Distinguish descriptive statistics from model-based estimates.
  • Preserve the prespecified treatment-effect definition.
  • Apply missing-data and intercurrent-event rules consistently.
  • Handle multiplicity explicitly.
  • Perform independent statistical and presentation QC.
  • Reconcile tables, figures, listings, and CSR text.
  • Maintain complete traceability from the final table back to the analysis data.

References

International Council for Harmonisation (ICH). ICH E3: Structure and Content of Clinical Study Reports.

International Council for Harmonisation (ICH). ICH E9: Statistical Principles for Clinical Trials.

International Council for Harmonisation (ICH). ICH E9(R1): Addendum on Estimands and Sensitivity Analysis in Clinical Trials.

International Council for Harmonisation (ICH). ICH E6(R3): Good Clinical Practice.

European Medicines Agency. Guideline on Missing Data in Confirmatory Clinical Trials.

U.S. Food and Drug Administration. Statistical Principles for Clinical Trials.