Tools for Combining Data Across IPUMS Global Health Surveys

By Miriam King, Devon Kristiansen, and Anna Bolgrien

IPUMS Global Health includes integrated data from three international health surveys: Demographic and Health Surveys (IPUMS DHS), Multiple Indicator Cluster Surveys (IPUMS MICS), and Performance Monitoring for Action (IPUMS PMA). All three surveys are nationally representative, primarily focus on low- and middle-income countries, and address issues related to the health and well-being of women and young children. These commonalities make combining integrated data across these data collections appealing. As Figure 1 shows, IPUMS DHS and IPUMS MICS cover different countries; combining them extends the geographic coverage of harmonized versions of data covering similar topics. Researchers can also combine data for those countries included in both IPUMS DHS and IPUMS MICS to provide additional observation points for time-series analyses.

Figure 1: Countries covered by IPUMS DHS and IPUMS MICS

World map with the countries included in IPUMS MICS and IPUMS DHS shaded in

Researchers who want to carry out cross-survey analyses face practical challenges. IPUMS imposes consistent variable names and codes within one kind of survey (DHS, MICS, or PMA); harmonized variable names and codes differ between these surveys. On each project’s website, the documentation for each variable highlights comparability issues to keep in mind when combining multiple samples, either within one type of survey or across survey types. IPUMS users must make separate customized data files from each database and merge those files. And subtle differences in question wording, skip patterns, geographic boundaries, and sampling procedures—such as MICS’ taking reports on child health from caretakers other than the biological mother—can introduce inconsistencies and inadvertent errors.

Continue reading…

Constructing comparable intimate partner violence indicators across the DHS, MICS, and PMA health surveys

By Miriam King, Anna Bolgrien, Mehr Munir, and Devon Kristiansen

The three data series comprising IPUMS Global Health—IPUMS DHS, IPUMS PMA, and IPUMS MICS—contain intersecting subjects related to women’s and children’s health, while retaining distinct patterns of temporal and geographic coverage. This content overlap opens the door to combining harmonized data across the three surveys, to extend time series and/or increase the number of countries in comparative analyses. However, there are important yet subtle differences between these survey types, in sample frames, questionnaire wording, and variable responses and universes, which require cautious consideration. As the example below demonstrates, researchers must use extra care to avoid errors when combining data across IPUMS DHS, MICS, and PMA.

A July 2024 article in the Journal of Public Health Policy, “Constructing Comparable Intimate Partner Violence Indicators across DHS, MICS, and PMA Health Surveys,” describes some challenges and solutions to combining data across these IPUMS databases, using measures of intimate partner violence as an example. The piece, authored by Devon Kristiansen and colleagues at IPUMS, notes two necessary steps in combining data across survey types:

  • Identify and combine only variables with similar question wording
  • Adjust the samples to include only comparable subpopulations

Continue reading…

Making Your Customized IPUMS MICS Data File

By Anna Bolgrien

The newest IPUMS data collection, IPUMS MICS, has many similarities with other IPUMS microdata collections. However, there is one major difference: the IPUMS MICS Data Extract System only uses Stata.

Yes, you read that right. Users of IPUMS MICS must use Stata to open and create their customized data file.

Let’s start with how using IPUMS MICS is the same as using other IPUMS microdata collections.

If you are an IPUMS user, you will find the process of browsing the variables, looking at documentation, and adding samples to your data cart completely familiar. If you are not familiar with IPUMS, you can read more about browsing and selecting variables.

However, when you finish choosing variables and samples in IPUMS MICS and click “Create Extract,” things start to look different.

Normally, you could change the data format, but the only option currently available for IPUMS MICS is a .dat (fixed-width text) file format.

Continue reading…

Announcing IPUMS MICS

By Anna Bolgrien

IPUMS MICS Logo

IPUMS has an exciting new data collection to announce: IPUMS MICS!

IPUMS MICS is the integrated version of UNICEF MICS (Multiple Indicator Cluster Surveys), the largest and most robust source of data on women and children’s well-being across the globe, including countries in Africa, Eastern Europe, Asia, and Latin America. Separate datasets cover women of childbearing age, children aged 0 to 4, children aged 5 to 17, respondent’s birth history, men, household members, and household characteristics.

Currently, IPUMS MICS includes harmonization of data from 202 MICS samples, which represent 88 countries, and cover surveys conducted between 2005-forward. There are over 800 integrated variables currently available on our website. Future releases will expand the sample and variable coverage of IPUMS MICS.

Continue reading…