The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Data » Merging data files » Mismatch of file names within the same survey
Mismatch of file names within the same survey [message #24247] Mon, 28 March 2022 23:53 Go to next message
Olena Stavrunova is currently offline  Olena Stavrunova
Messages: 2
Registered: November 2021
Dear all,
I am trying to match the BR and PR data for several surveys. I noticed that for some surveys the name of BR files does not correspond to the name of the PR file. For examples, Indonesia 2007 has IDBR51DT.ZIP and IDPR52DT.ZIP - notice different survey release code: 51 vs 52. There are many similar examples from other countries. Could you please explain what this means and whether these two files can still be merged? I attach a screenshot FYI.
Thank you
Re: Mismatch of file names within the same survey [message #24303 is a reply to message #24247] Fri, 15 April 2022 16:01 Go to previous message
admin is currently offline  admin
Messages: 42
Registered: November 2012
Following is response from DHS Research & Data Analysis Director, Tom Pullum:

You have identified a nuisance that we often have to deal with. Column 6 of the filename is a "version" code. Sometimes (for a range of reasons) the DHS data processing staff will update a file and will increment the version code (for example from 1 to 2) for that file. If the other files for that survey are not affected, their version codes will not be changed. If you previously would have merged BRxx51 with PRxx51, you would now merge BRxx51 with PRxx52, for example.

When looping through lots of surveys, you may hit a problem like this. A related problem comes up if both files were 51 and now both are 52. You have to have enough flexibility to handle such changes/updates in filenames.

Note that you need the version number because the phase identifier in column 5 is not sufficient to identify a survey. For example, Egypt had both 51 and 5A surveys--two surveys within DHS-5.

We now have repositories of code written in Stata and SPSS available on Github. Please reference these code repositories as a resource for code for matching or calculating DHS indicators. The code repositories can be found at:

Previous Topic: Merging data sets
Next Topic: Struggling with merging Senegal KR data file to mother's file
Goto Forum:

Current Time: Thu Jun 30 10:20:06 Coordinated Universal Time 2022