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.
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:
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:
A further 14 eligible records are excluded because a prespecified analysis variable was unavailable at the required stage. The analysis sample is therefore:
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:
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\).
| Variable | Observed | Missing | Reported role |
|---|---|---|---|
| Age | 478 | 14 | Imputation target |
| Severity | 451 | 41 | Imputation target |
| Outcome | 485 | 7 | Imputation target |
| Site | 492 | 0 | Predictor; 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:
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.
Specify whether counts refer to people, records, visits, or another unit, and identify the initial data source or screening stage.
Give counts after each transition and state exclusion reasons. Check that the counts reconcile under the stated rules.
For each relevant variable, show observed and missing counts and label whether it was an imputation target, predictor, identifier, or otherwise not imputed.
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.
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.
- A study screens 240 records and excludes 12 ineligible and 8 duplicate records, with no overlap. How many records remain?
- An analysis has 300 records. A variable has 276 observed values. How many missing values should its table report?
- 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?
- A run requests 25 completed datasets, retains 23, and each retained dataset has 180 records. What quantities should be reported?
- 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.