Imputing partial birth dates using day of the week
Johnson, C. Y.
Show abstract
BackgroundIn deidentified data, exact dates are suppressed to maintain confidentiality of research participants. When the partial date includes only month and year, researchers who need exact dates must impute a day of the month. In some deidentified datasets, day of the week is also provided, but this variable is uncommonly incorporated into the imputation of partial dates. Our objective was to examine the extent to which misclassification is reduced by incorporating day of the week into partial date imputation. MethodsWe simulated a population of 594,677 people using the distribution of birthdays in England and Wales in 2024. We imputed birth dates using four methods: (1) first day of the month, (2) 15th of the month, (3) randomly selecting a day of the month, and (4) randomly selecting a day of the month conditional on day of the week. We quantified misclassification as the median number of days between the imputed and true birth date and as the cumulative percentage of the population whose imputed birth date fell within a given number of weeks of their true birth date. ResultsIncorporating day of the week reduced misclassification, with a median of 7 days between imputed and exact birth date compared to 8-15 for the other methods. For nearly a quarter of the population, their imputed birth date was their true birth date, compared to 3% in other methods. However, using the 15th day of the month was the best method to ensure that no misclassification was greater than 3 weeks. ConclusionIncorporating day of the week into random day selection reduced misclassification. This method is easily accomplished in standard statistical software.
Matching journals
The top 6 journals account for 50% of the predicted probability mass.
Similar papers in this journal
- Birhan Maternal and Child Health cohort: a study protocol 90%
- Methodological Considerations for Linking Household and Healthcare Provider Data for Estimating Effective Coverage: A Systematic Review 90%
- Sex ratios and ‘missing women’ among Asian minority and migrant populations in Aotearoa/New Zealand: A retrospective cohort analysis 90%
Similar papers in this journal
- Pregnancy pharmacoepidemiology: How often are key methodological elements reported in publications? 89%
- A Systematic Process for Assessing Fitness-for-Purpose of Health Outcomes for Computable Phenotyping with Electronic Health Record Data 88%
- Using quantitative bias analysis to adjust for misclassification of COVID-19 outcomes: An applied example of inhaled corticosteroids and COVID-19 outcomes 88%
Similar papers in this journal
- Quantitative bias analysis for mismeasured variables in health research: a review of software tools 90%
- Completeness of reporting of clinical prediction models developed using supervised machine learning: A systematic review 89%
- Comparing methods to predict baseline mortality for excess mortality calculations 89%
"Similar papers" are the closest papers from that journal in the model's embedding space. They show what the match is built on, but the ranking comes mostly from a classifier over the whole training set, not from these examples alone.