VerifiedEvidence: highv1.0.0

Last Observation Carried Forward

A missing data method substituting a participant's most recent value for all subsequent missing time points, assuming their condition stayed unchanged.

Last reviewedDarrin Baines IP Ltd

Concept Architecture

Concept


Theoretically, Last Observation Carried Forward (LOCF) is a single imputation method for handling missing longitudinal data in which the most recent observed value for an individual is substituted for all subsequent missing observations. The method assumes that the participant's outcome remains unchanged after the last recorded measurement. LOCF was historically widely used in clinical trials because of its simplicity and ability to preserve sample size in intention-to-treat analyses, although its statistical limitations are now well recognised.

Mathematically, LOCF is represented as a deterministic imputation rule rather than a statistical model. Missing observations occurring after the final observed value are replaced with that value, creating a complete dataset for subsequent statistical analysis. The method does not estimate missing values probabilistically and therefore ignores uncertainty associated with the imputation, which can introduce bias and underestimate variance.

In practice, LOCF is implemented by identifying the final observed value for each participant and carrying that value forward to replace all subsequent missing observations. In health economics, LOCF has been applied to longitudinal quality-of-life measures, utility values, costs and clinical outcomes collected alongside randomised controlled trials. Current methodological guidance generally recommends model-based methods such as multiple imputation or mixed-effects models in preference to LOCF because they better account for uncertainty and missing-data mechanisms.

Purpose


Used to create complete longitudinal datasets by replacing missing follow-up observations with the participant's last observed value, allowing conventional statistical analyses to be performed while preserving the analysed sample size.


Mathematical Formulae

Primary Formula

For participant i:

Y?,t = Y?,t??for all t > t? where Y?,t is missing

where:

  • Y?,t = imputed value at time t
  • Y?,t? = last observed value before missingness
  • t? = final observed time point

Supporting Formulae

There is no universally recognised canonical mathematical formula.

Related Mathematical Methods

  • Multiple Imputation
  • Mixed-Effects Models
  • Maximum Likelihood Estimation
  • Complete Case Analysis
  • Baseline Observation Carried Forward
  • Pattern Mixture Models

Example

A clinical trial measures EQ-5D utility at baseline, 3 months, 6 months and 12 months.

A participant has the following observed utilities:

  • Baseline = 0.70
  • 3 months = 0.78
  • 6 months = Missing
  • 12 months = Missing

Using LOCF:

  • Utility at 6 months = 0.78
  • Utility at 12 months = 0.78

The completed dataset can then be analysed, although the approach assumes that the participant's health status remained unchanged after the 3-month assessment.


Excel Implementation

FunctionExample FormulaHealth Economics Application
IF=IF(B2="",A2,B2)Replace a missing value with the previous observation.
INDEX=INDEX($A2:B2,1,COUNTA($A2:B2))Retrieve the most recent non-missing observation in a row.
LOOKUP=LOOKUP(2,1/(A2:D2<>""),A2:D2)Return the last observed value before missing data.
COUNTA=COUNTA(A2:D2)Identify the number of observed follow-up values.

VBA (Optional)

A VBA routine can automatically identify missing follow-up observations and populate them using each participant's last recorded value across longitudinal datasets.


Sources

  • Little RJA, Rubin DB. Statistical Analysis with Missing Data. Wiley.
  • National Research Council. The Prevention and Treatment of Missing Data in Clinical Trials. National Academies Press.
  • Carpenter JR, Kenward MG. Multiple Imputation and Its Application. Wiley.
  • Bell ML, Fiero M, Horton NJ, Hsu CH. Handling Missing Data in RCTs: A Review of the Top Medical Journals. BMC Medical Research Methodology. 2014.
  • Briggs A, Claxton K, Sculpher M. Decision Modelling for Health Economic Evaluation. Oxford University Press.
  • NICE. Health Technology Evaluation Manual.

Library

Publications

1
  • Book

    Statistical Analysis of Cost-Effectiveness Data — Willan & Briggs, 1st Edition ed., 2006 (John Wiley & Sons)

    A synthesis of statistical methods for analysing cost-effectiveness data, including net-benefit regression, confidence intervals for the ICER, cost-effectiveness acceptability curves, and covariate adjustment. Part of the Wiley Statistics in Practice series.

Frequently Asked Questions (6)

  • What is last observation carried forward?

    A missing data method substituting a participant's most recent value for all subsequent missing time points, assuming their condition stayed unchanged.

    Source: Molenberghs & Kenward 2007

  • How does last observation carried forward fill in missing data?

    Last observation carried forward fills a participant's missing later values by repeating their most recent recorded value, carrying it forward to every subsequent time point they missed. This rests on the questionable assumption that the person's condition stayed exactly as it was when last measured, which is often false for progressive diseases. Once common in trials, it is now widely criticised for the bias it introduces, and multiple imputation is generally preferred. Freezing the last value onward is its method. Little and Rubin (2002) discuss this.

    Source: Little & Rubin 2002

  • Why is last observation carried forward criticised?

    Last observation carried forward is criticised because its assumption that a participant's outcome stays unchanged after dropout is often unrealistic, since conditions typically change over time, so carrying the last value forward can bias the results in either direction and understate the uncertainty by treating imputed values as known. So last observation carried forward is criticised for resting on an implausible constancy assumption that can distort estimates and give falsely precise inference, which is why it is now generally discouraged as a primary analysis in favour of principled methods such as multiple imputation or mixed models that make more reasonable assumptions and properly reflect the uncertainty in the missing data.

    Source: Molenberghs & Kenward 2007

  • What assumption does last observation carried forward make?

    Last observation carried forward assumes that a participant's outcome remains unchanged from their last observed value onward, so that the missing later measurements would have equalled the last one recorded. This is a strong and often unrealistic assumption, since outcomes usually change over time, whether improving or worsening. So last observation carried forward rests on the assumption of no change after the last observation, which rarely holds in practice, and this is the source of its potential bias, since if participants would in fact have improved or deteriorated, carrying the last value forward misrepresents their outcomes and can systematically distort the estimated treatment effect.

    Source: Molenberghs & Kenward 2007

  • What are the alternatives to last observation carried forward?

    The alternatives to last observation carried forward include principled methods such as multiple imputation, which imputes plausible values reflecting uncertainty; mixed models for repeated measures and other likelihood-based methods, which use all available data validly under the missing at random assumption; and reference-based imputation approaches for specific settings. So rather than carrying the last value forward, the alternatives handle missing data with methods that make more reasonable assumptions and properly reflect the uncertainty, which is why multiple imputation and mixed models are generally preferred, with last observation carried forward now largely avoided as a primary analysis and, at most, used as a sensitivity analysis.

    Source: Molenberghs & Kenward 2007

  • When was last observation carried forward used?

    Last observation carried forward was widely used in the past for analysing longitudinal trials with dropout, valued for its simplicity and once accepted, sometimes on the belief that it was conservative. Its limitations have since led to its decline. So last observation carried forward was historically common in trial analysis but is now generally discouraged, since its constancy assumption is unrealistic and its supposed conservatism is not guaranteed, which is why regulatory and methodological guidance has shifted toward principled missing data methods, leaving last observation carried forward as an approach to be avoided for primary analyses and used, if at all, only in sensitivity analyses.

    Source: Molenberghs & Kenward 2007

Trust Record

Verified by Dr Darrin Baines

British health economist

Professional identity: darrinbaines.org

Verification date: 17 Dec 2025

Content version: 1.0.0

Canonical Identity

Term code
HE-ES-SA-095

Stable URI · Machine-readable · Resolvable · CC BY 4.0