Tutorials › Multiple Imputation by Chained Equations (MICE) › Reporting Sample Flow and Imputation Outputs

Software, Reporting and Pitfalls · Tutorial 490 of 497

Reporting Sample Flow and Imputation Outputs

Build an auditable account of who entered the analysis, what was imputed, and how many completed datasets were produced.

Intermediate 10 min read

What You'll Learn

  • Define consistent units and stages for a sample-flow account.
  • Reconcile screened, excluded, and analyzed record counts.
  • Report observed and missing counts for each relevant variable.
  • Distinguish imputation targets from predictors and other variables.
  • Report planned and successfully retained completed datasets.
  • Recognize what accounting tables cannot establish about an imputation.

Why Sample Flow and Imputation Counts Belong in the Report

Readers need to know not only how an imputation was run, but also which records and variables it involved. A compact accounting table can answer practical questions: How many records were screened? How many entered the analysis? Which variables were imputed? How many completed datasets were actually retained? Without clear counts, even a technically detailed description can leave the analyzed sample difficult to reconstruct.

This tutorial focuses on reproducible accounting. It does not use counts to explain why values were missing or to assess the adequacy of the imputation. Those are different tasks. A sample-flow table records the sequence of defined data-processing stages; a variable-level table records the observed and missing values before imputation and what happened to each variable; and an output summary records the completed datasets available for subsequent analysis.

Definition: A sample-flow account is a record of the number of eligible units at named stages of data processing, together with explicit reasons for any exclusions. A variable-level imputation account identifies the variables considered, their observed and missing counts before imputation, and their role in the imputation. An imputation-output account states how many completed datasets were requested, successfully created, and retained, and how many records each contains.

Set the Counting Rules Before Making the Table

A count is interpretable only when its unit and stage are clear. The unit might be a person, visit, specimen, or record; these are not interchangeable. For example, 500 people can contribute 620 visits. If the analysis uses one row per visit, reporting “500 observations” would not describe the data supplied to MICE. State whether each count refers to unique participants, records, or another unit, and use that unit consistently within each flow.

Define the starting point and each transition. If a stage removes records, give both the number removed and the rule for removal. When exclusions have multiple reasons, make the categories mutually exclusive or say explicitly that reasons can overlap. Otherwise readers may add overlapping counts and incorrectly expect them to equal the total excluded. For a sequential flow with mutually exclusive exclusions, the basic reconciliation is:

$$ N_{\text{next stage}} = N_{\text{current stage}} - N_{\text{excluded at this stage}}. $$

The equality is a useful audit check, not a statistical assumption about the missing-data process. It requires the same unit to be counted on both sides and exclusions to be assigned to the stated transition. Keep counts from different stages separate: the number screened is not automatically the number eligible, and the number eligible is not automatically the number analyzed.

Worked Example: Reconciling the Analysis Sample

Suppose a hypothetical project begins with 530 submitted records. A record-level review identifies 18 ineligible records and 6 duplicate records. These exclusion categories are defined to be mutually exclusive, and each record is counted once.

The number of unique eligible records is:

$$ 530 - 18 - 6 = 506. $$

A further 14 eligible records are excluded because a prespecified analysis variable was unavailable at the required stage. The analysis sample is therefore:

$$ 506 - 14 = 492. $$

Equivalently, the total excluded is \(18+6+14=38\), and \(530-38=492\). A report should name the unit (“records”), the stage for each exclusion, and the rule behind it. It should not describe these counts as 530 people unless the records have been verified to correspond one-to-one with unique people.

Report Variable Counts and Imputation Roles

The flow table describes units; it does not show how much data were missing in particular columns. For that, report variable-level counts at a specified pre-imputation stage, usually the analysis data supplied to MICE. For each relevant variable, give the number observed and the number missing. If the analysis sample has \(n\) records and each record has either an observed or missing value for that variable, the counts should satisfy:

$$ n_{\text{observed}} + n_{\text{missing}} = n. $$

Also state each variable’s role. An imputation target is a variable for which missing entries are filled in during imputation. A predictor may be used to help impute other variables without itself being imputed. An identifier may be retained for record linkage but excluded from the imputation model. These roles should not be conflated: appearing in the imputation model does not by itself mean that a variable was imputed.

A useful table can include the variable name, observed count, missing count, and role. If a variable has no missing values, reporting it as a predictor or as “not imputed” can make its status clear. If a variable has missing values but was not imputed, state that fact and the analysis decision in neutral, specific terms. Do not let readers infer that every incomplete variable was an imputation target.

Worked Example: Calculating Variable-Level Counts

In the hypothetical analysis sample of 492 records, the pre-imputation data have 478 observed age values, 451 observed severity values, and 485 observed outcome values. Site is observed for all 492 records. The missing count for each variable is found by subtracting its observed count from 492.

For age, \(492-478=14\) values are missing. For severity, \(492-451=41\) are missing. For outcome, \(492-485=7\) are missing. For site, \(492-492=0\) are missing. Each row reconciles: for example, \(478+14=492\).

VariableObservedMissingReported role
Age47814Imputation target
Severity45141Imputation target
Outcome4857Imputation target
Site4920Predictor; not imputed

These are variable-level counts, not counts of distinct records with any missing value. A record may have missing values in more than one variable, so adding \(14+41+7=62\) counts missing cells, not necessarily 62 different records. The table also does not explain why values are missing; it only reports their status at the stated stage.

Account for the Completed Datasets

A MICE run may be configured to create a requested number of completed datasets, often denoted \(m\). In the report, distinguish the requested number from the number that were actually completed and retained for analysis. If all requested datasets were produced and retained, these counts agree; if not, report the discrepancy and the disposition of incomplete or failed outputs. The number of iterations used to generate imputations is not the number of completed datasets.

Also state the record count in each retained completed dataset. If the workflow is designed to retain every analysis record, the row count should agree with the analysis-sample count. A discrepancy should be investigated and explained, rather than hidden by reporting only a total number of rows after stacking datasets. The stacked total counts repeated representations of the same analysis records across completed datasets; it is not a count of unique participants or records.

Worked Example: Reporting Requested and Retained Outputs

Suppose a hypothetical MICE run was configured to create \(m=20\) completed datasets from the 492-record analysis sample. Run logs and saved outputs confirm that all 20 were completed and retained, and inspection confirms that each contains 492 records.

The report can state: “Twenty completed datasets were requested; 20 were successfully created and retained. Each contains 492 analysis records.” If the datasets are stacked for storage, the stack contains \(20\times492=9{,}840\) rows:

$$ 20 \times 492 = 9{,}840. $$

That number describes dataset-record rows in the stack, not 9,840 distinct analysis records. The report should preserve the distinction between \(m=20\) completed datasets and 492 records represented in each one.

Assemble and Audit the Accounting Table

A clear report can use one table for the sample flow and a second for variables and outputs, or a single carefully structured table with separate panels. Combining everything into one undifferentiated list can make the units hard to follow. The following sequence is a practical construction method.

1
Name the unit and starting point.
Specify whether counts refer to people, records, visits, or another unit, and identify the initial data source or screening stage.
2
List sequential stages and exclusions.
Give counts after each transition and state exclusion reasons. Check that the counts reconcile under the stated rules.
3
Summarize variables at the pre-imputation stage.
For each relevant variable, show observed and missing counts and label whether it was an imputation target, predictor, identifier, or otherwise not imputed.
4
Summarize retained outputs.
Report the requested and retained number of completed datasets, and the record count in each, noting any deviations from the planned run.

For a final audit, verify that each row’s stage is named, each count has a stated unit, and the variable counts correspond to the same analysis sample described by the flow. Check the arithmetic rather than assuming a table is correct because it looks plausible. If exclusions can overlap, label them accordingly instead of presenting their sum as a unique total. If a completed dataset has fewer records than expected, explain the difference using the actual workflow record rather than silently changing the denominator.

What the Accounting Does—and Does Not—Show

This style of reporting is useful because it supports reproducibility and interpretation of the study’s sample without requiring a reader to reconstruct counts from prose. A flow diagram can make the sequence of inclusions and exclusions visually prominent; a table can give more detail about variable roles and missing counts; a concise narrative can explain unusual decisions. These are complementary presentation choices. Whatever format is used, the same count and definition should not change from one part of the report to another.

Accounting is not a substitute for reporting the implemented workflow, software information, or diagnostics. In particular, counts of missing values do not establish a missingness mechanism, prove that the imputation model is appropriate, or show that the MICE algorithm behaved well. Likewise, a large retained \(m\) does not by itself establish convergence or satisfactory imputation. Those questions require other information and checks; the accounting table should not be asked to answer them.

Key takeaway: Keep three quantities distinct: units passing through analysis stages, missing values counted by variable before imputation, and completed datasets retained after imputation. Define each count, use a consistent unit, and show enough arithmetic for readers to verify the account.

Common Mistakes

  • Adding variable missing counts and calling the sum “people with missing data.” The sum counts missing cells; one record can contribute more than one cell. Report the number of distinct incomplete records only if it was separately counted.
  • Reporting only a final sample size. A final count does not reveal the starting population, exclusions, or reasons for exclusions. Show the stages needed to explain how the analysis sample arose.
  • Calling predictors imputed variables. A variable can help predict missing values in other variables without having its own missing values filled in. Report predictor and target roles separately.
  • Equating iterations, stacked rows, and completed datasets. Iterations are part of the computational procedure; stacked rows count repeated dataset-record pairs; \(m\) counts completed datasets. State each quantity by its proper name.
  • Treating a reconciled table as evidence of a valid imputation. Arithmetic checks support accurate accounting, but they do not establish model adequacy, convergence, or a missingness mechanism.

Check Your Understanding

Answer each question using the stated counting unit. Solutions follow the questions.

  1. A study screens 240 records and excludes 12 ineligible and 8 duplicate records, with no overlap. How many records remain?
  2. An analysis has 300 records. A variable has 276 observed values. How many missing values should its table report?
  3. Three variables have 10, 15, and 5 missing values. Can you conclude that exactly 30 records have at least one missing value? Why or why not?
  4. A run requests 25 completed datasets, retains 23, and each retained dataset has 180 records. What quantities should be reported?
  5. A fully observed site variable is used to predict other variables, but its values are not filled in. Is it an imputation target? How should its role be reported?

Solutions. (1) The exclusions are mutually exclusive, so \(240-12-8=220\) records remain. (2) The missing count is \(300-276=24\), since observed and missing values partition the 300 records for that variable. (3) No. The sum of 30 counts missing cells; records missing in multiple variables contribute more than once, so the number of distinct incomplete records must be counted separately. (4) Report that 25 were requested and 23 were successfully retained, state the reason or disposition of the two not retained if known, and report 180 records in each retained dataset. Do not imply that all 25 were available for analysis. (5) No. It is a predictor, not an imputation target; report it as fully observed and used as a predictor, not as a variable whose missing values were imputed.

Clinical Biostats