Trends in Demographic and Health Survey data quality: an analysis of age heaping over time in 34 countries in Sub Saharan Africa between 1987 and 2015
BMC Research Notes volume 10, Article number: 760 (2017)
This paper evaluates one aspect of data quality within DHS surveys, the accuracy of age reporting as measured by age heaping. Other literature has explored this phenomenon, and this analysis build on previous work, expanding the analysis of the extent of age heaping across multiple countries, and across time.
This paper makes a comparison of the magnitude of Whipple’s index of age heaping across all Demographic and Health Surveys from 1986 to 2015 in Sub-Saharan Africa. A random slope multilevel model is used to evaluate the trend in the proportion of respondents within each survey rounding their age to the nearest age with terminal digit 0 or 5. The trend in the proportion of misreported ages has remained flat, in the region of 5% of respondents misreporting their age. We find that Nigeria and Ghana have demonstrated considerable improvements in age reporting quality, but that a number of countries have considerable increases in the proportion of age misreported, most notably Mali and Ethiopia with demonstrate increases in excess of 10% points.
Much attention has been paid to ensuring that basic data within Demographic and Health Surveys is correctly measured. Age heaping is frequently encountered and presents significant problems for accurate collection of data. Age heaping or age preference is the tendency for people to incorrectly report their age or date of birth. Individuals’ heaping behaviours favour certain ages, commonly those ending in ‘0’ or ‘5’  although there is some evidence of minor heaping at eight .
At the most basic level, inclusion of women age 15–49 in DHS depends on accurate reports of the ages of women near the boundaries of that age interval in the survey. The inclusion of children under five (or another specified age) for the questions about child health, immunizations, and nutrition also depends on accurate reports of their birth dates. Many measures are age-specific, such as estimates of age-specific fertility rates and infant and child mortality rates [C]. Estimates of levels and trends in such rates may be affected by misreporting of ages and dates of birth for a woman and her children, or dates of death for her children. Age displacement of children can seriously distort estimates of current levels and recent trends in fertility and mortality and is by no means unique to DHS surveys: evaluation of censuses and community surveys have revealed severe age misreporting [2,3,4]. Additionally, age heaping can have implications for the quality of analyses into other phenomena, such as cause specific death rates . This has led to a plethora of studies evaluating the quality of basic demographic data in the DHS in a variety of contexts [6,7,8,9].
Our analysis provides an evaluation of how the excess proportion varies over time and between countries. This analysis expands on previous works [7, 10], increasing the range of countries evaluated as well as capturing trends across time, to account for potential structural change which may improve the quality of retrospective data  as well as better data collection techniques [11, 12]. Our working hypothesis is that there should be a falling trend in the proportion of ages showing digit preference across time.
As such, this paper addresses two major research aims:
Capturing the overall trend in the quality of age recall data across multiple waves of DHS surveys.
Evaluate the extent of cross national variation in the extent of age heaping.
DHS are nationally representative, cross-sectional household surveys with multi-stage cluster sampling designs. Respondents are women of reproductive age (which are defined by DHS as between 15 and 49 years) and only women between these ages are interviewed. While a male dataset is available, and digit preference is also exhibited albeit to a lower extent for males , collection is much less consistent (especially for early surveys) and so the analysis is limited to females only. Exact details of the sampling designs are available on a country by country basis, and data sets can be downloaded on request from the provider. We restrict our analysis to the Sub Saharan Africa region to minimize the extent to which cross cultural variation in age heaping may play a role .
Whipple’s index of age heaping
This analysis uses Whipple’s index of age heaping to measure age data quality [4, 13]. Whipple’s index measures the excess proportion of ages ending in either 0 or 5. Where no ages are heaped, we expect this index to take the value 0.2. Deviation from this number indicates some degree of terminal digit preference, for example 0.25 indicating that 5% of ages have been heaped at either a zero or five terminal digit.
We specify the dependent variable in our model as the excess proportion of ages ending in 0 or 5 from (Whipple’s index of heaping), denoted as y tj where y is the proportion of respondents with heaped ages, indexed by year of survey t and country j. Survey years are hierarchically nested within countries. We specify a multilevel model in the form of Eq. 1, where the logit of the index of heaping is a function of the year of the survey with intercountry variation captured a random effect parameter at the country level, ν j.
To overcome the non-linearity of the proportion of age heaped at zero, we use a logit link to allow the specification of the model in the linear form of Eq. 1. We explored different specifications of the year of survey parameter by introducing square and cubic terms for the effect of year to account for non-linearity but neither of these specifications improved model fit on -2LogLikelihood significance tests.
We performed tests for differences in the trend in the proportion of ages heaped over time by introducing a random slope parameter at the country level. This model is described in Eq. 2
In Eq. 2, the random effect parameter ν 1j allows deviation from the overall trend in Whipple’s index of heaping over time according to indexation by country j. This parameter is allowed to correlate with ν 0j .
Model estimation is conducted by taking the logit of Whipple’s index of heaping, and using this as the response variable in a linear multilevel analysis. Models are estimated using MlwiN 2.36 , with Restricted Iterative Generalised Least Square (2nd order Penalised Quasi Likelihood) estimation used to account for the low number of observations per country.
The countries included, the years of survey and the proportion of 0 and 5 terminal digits are presented in Table 1. The overwhelming majority of surveys exhibit proportions.
Results from the modelling are presented in Table 2. We find no evidence of a trend toward an improvement in the proportion of ages heaped, with the coefficient from both Model I and Model II being both statistically non-significant and substantively small.
The introduction of the random slope parameter proved to significantly improve model fit based on a likelihood test. The predicted values by country from Model 2 are presented in Fig. 1. The overall trend in the proportion of age heaped in denoted by the red line within individual country trajectories denoted for each blue line. In general, there is a reasonable degree of clustering around the population line: the majority of countries have a portion of age heaped which is consistent over time, and in the range of between 2 and 6%.
Based on the predicted values of Whipple’s index of heaping, we identify countries with substantial differences between survey years 1987 and 2015 based on the residuals from model 2. We identify two countries with large predicted decreases in the proportion of age heaped, where we define a large decrease as being 4% points or more. Nigeria exhibits the largest decrease in the proportion of respondents reporting a heaped age, with a decline in the predicted value of Whipple’s index of 6.22% points, with the only other country exhibiting a large substantive decrease in the proportion of respondents with a heaped age being observed in Ghana with a fall of 4.28% points.
A number of countries exhibit substantive increases in the proportion of respondents reporting a heaped age, again defined as an increase of 4% points or more between the predicted values of Whipple’s index between 1987 and 2015. Sierra Leone, Chad and Ethopia demonstrate increases of 4.46% points, 7.38% points and 7.58% points respectively. We also note exceptionally large increases in the proportion of respondents with a heaped age in excess of 10% points between 1987 and 2015: Mali exhibits and increase of 11.78% points and Benin increases by 13.87% points.
Data quality from retrospective sample surveys continues to be of major importance in social science, and basic demographic data is no exception. This paper therefore provides an assessment of the quality of age reported data within the DHS. We use all available DHS for the Sub Saharan Africa region to assess trends over time in the proportion of age reported which are heaped on terminal digits 0 and 5.
Out initial research hypothesis was that there may be a secular trend toward lower proportions of age heaped. However, in our analysis, we find no evidence of a significant decline in the proportion of ages heaped. That said the predicted probabilities are at a relatively low level for most countries, and are not a substantial concern. We do however identify some major outliers: Nigeria and Ghana have considerable falls in the proportion of ages heaped, while there have been dramatic increases in Sierra Leone, Ethiopia and Chad.
DHS data have provided detailed insight into developing countries but over time its methods have evolved. Research models can better cope with attitudes and behaviours in the field and the process, in recent years, allows for improved cultural translations. This has indeed reduced heaping in some areas and analyses from Sub-Saharan Africa show some improvement in data accuracy, along with increased levels of development. There appears to have been an adjustment for temporality being socially, culturally and economically defined, indicating that age heaping remains a mutable phenomenon.
This has been noted for other basic demographic information [8, 11, 12] where improvements in data collection procedures and provision of written information to increasingly literate populations  and better collection [8, 11, 12] techniques have been means of improving the accuracy of recalled data, for example birth weight [7, 8]. Potential explanations for improving data quality largely fall into the realms of better quality information being provided by respondents, and better collection techniques. Considering the effect of respondents, increasing utilisation of written demographic information made possible by greater levels of numeracy  has led to improvements over time in demographic data quality. Low numeracy and vague ideas about date of birth which were potentially down to low degrees of schooling . Additionally, falling rates of malnutrition may be a potential explanation, as infant protein malnutrition syndrome was and is (in poorest economies) a limiting factor in an adult’s cognitive abilities (which can cause misreports in age) .
Consideration of the use of new techniques to reduce inaccuracies, such as calendars, as more recent versions of the DHS record additional variables Similar technique of alternate measures of timepaths using ‘local calendars’ that referenced local events and festivals which corresponded to the individual’s personal life . This method is relatively successful in that respondents memory was triggered resulting in less duration heaping.
These advancements framed the motivation for our research hypothesis that the prevalence of age heaping would fall across time. While we find little evidence of this- there is no significant year effect in our models—indicating no movement toward secular improvement in the quality of age data. That said, out initial expectation of severe bias in certain contexts based on historic census information [2, 3] was also misplaced. While the lack of improvement in age data quality in the DHS is disappointing, this should be tempered by the fact the level of distortion is low to begin with. We do note some heterogeneity when taking country context into account, with some countries somewhat large changes in the degree of age misreporting. Tentatively, these changes can be explained by economic performance: relatively high growth rates in Nigeria and Ghana compared to moribund economic growth in Ethiopia and Chad exacerbated by internal conflict and violence which may have disrupted vital registration procedures. In any case, this study highlights the need to take into account country context when analysing data quality, even for standardised datasets such as the DHS.
This analysis is only able to identify the proportion of ages in a population with digit preference, not whether individuals are misreporting their age.
National level averages are produced: the likelihood of heaping is likely to vary between sub national groups e.g. better educated women are less likely to misreport their age than women with low educational attainment due to better numeracy .
A’Hearn B, Baten J, Crayen D. Quantifying quantitative literacy: age heaping and the history of human capital. J Econ Hist. 2009;69(3):783–808.
Bailey M, Makannah TJ. An evaluation of age and sex data of the population censuses of Sierra Leone: 1963–1985. Genus. 1996;52(1–2):191–9.
Mukherjee BN, Mukhopadhyay BK. A study of digit preference and quality of age data in Turkish censuses. Genus. 1988;44(1–2):201–27.
Pardeshi GS. Age heaping and accuracy of age data collected during a community survey in the Yavatmal District, Maharashtra. Indian J Community Med. 2010;35(3):391–5. https://doi.org/10.4103/0970-0218.69256.
al-Haddad BJ, Jedy-Agba E, Oga E, Adebamowo C. Age heaping and cancer rate estimation in Nigeria. Working Paper 2013–03 Minnesota Population Centre; 2013.
Johnson K, Grant M, Khan S, Moore Z, Armstrong A, Sa Z. Fieldwork-related factors and data quality in the demographic and health surveys program. DHS analytical studies No. 19. Calverton, Maryland, USA: ICF Macro. 2009. http://dhsprogram.com/pubs/pdf/AS19/AS19.pdf. Accessed 3 Nov 2017.
Pullum TW. An assessment of the quality of data on health and nutrition in the DHS surveys, 1993–2003. DHS Methodological Reports 6 Calverton, Maryland, USA: Macro International. 2008. http://dhsprogram.com/pubs/pdf/MR6/MR6.pdf. Accessed 3 Nov 2017.
Channon AAR, Padmadas SS, McDonald JW. Measuring birth weight in developing countries: does the method of reporting in retrospective surveys matter? Matern Child Health J. 2011;15(1):12–8. https://doi.org/10.1007/s10995-009-0553-3.
Cleland J. Demographic data collection in less developed countries 1946–1996. Popul Stud. 1996;50(3):433–50.
Pullum TW. An assessment of age and date reporting in the DHS Surveys 1985–2003 DHS Methodological Reports No. 5. Calverton, Maryland, USA: Macro International. 2006. http://dhsprogram.com/pubs/pdf/MR5/MR5.pdf. Accessed 3 Nov 2017.
Becker S, Diop-Sidibé N. Does use of the calendar in surveys reduce heaping? Stud Fam Plann. 2003;34(2):127–32.
Haandrikman K, Rajeswari NV, Hutter I, Ramesh BM. Coping with time: using a local time-path calendar to reduce heaping in durations. Time Soc. 2004;13(2–3):339–62.
Shryock HS, Siegel JS. Methods and materials of demography. New York: Academic Press; 1976.
Leckie G, Charlton C. runmlwin—A program to run the MLwiN multilevel modelling software from within Stata. J Stat Softw. 2013;52(11):1–40.
Crayen D, Baten J. Global trends in numeracy 1820–1949 and its implications for long-term growth. Explor Econ Hist. 2010;47(1):82–99.
Barbieri M, Hertrich V, Grieve M. Age difference between spouses and contraceptive practice in Sub-Saharan Africa. Population. 2005;60(5/6):617–54. https://doi.org/10.2307/4148187 (English Edition, 2002-).
MJLA: data analysis, conceptualisation of study. TS: data preparation and cleaning, review of literature. Both authors read and approved the final manuscript.
The authors declare that they have no competing interests.
Availability of data and materials
Data are available on request from https://dhsprogram.com/Data/.
Consent to publish
Ethics approval and consent to participate
DHS receive government authorization, use informed consent and assurance of confidentiality for ethical use of data by third parties. Ethical approval provided by University of Portsmouth Faculty of Health Science and Social Work Ethics Committee.
Springer Nature remains neutral with regard to jurisdictional claims in published maps and institutional affiliations.
About this article
Cite this article
Lyons-Amos, M., Stones, T. Trends in Demographic and Health Survey data quality: an analysis of age heaping over time in 34 countries in Sub Saharan Africa between 1987 and 2015. BMC Res Notes 10, 760 (2017). https://doi.org/10.1186/s13104-017-3091-x
- Data quality
- Demographic and Health Survey