The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Data » Geographic Data » Merging DHS data sets with DANE municipality codes
Merging DHS data sets with DANE municipality codes [message #16555] Wed, 23 January 2019 16:17 Go to next message
ren_sof is currently offline  ren_sof
Messages: 4
Registered: January 2019
Member
Dear all,

I would like to merge municipality information for a different source with different DHS data sets for Colombia. I know that for 2005, 2010 and 2015 I have to concatenated the variable "department" and "municipality" on each survey to get the DANE municipality code. However, it has not been possible to do this with 1995 and 2000 waves as the "smunip" is code from 1 to 61 specific to DHS for surveyed municipalities that can not be used with the official DANE municipalities codes. What can I do? Could you please help me to obtain the municipality code used by the Colombian Statistical office(DANE) in 1995 and 2000 waves?

Thank you.

Sofia

[Updated on: Wed, 06 February 2019 16:59]

Report message to a moderator

Re: Merging DHS data sets with DANE municipality codes [message #18812 is a reply to message #16555] Tue, 25 February 2020 16:18 Go to previous messageGo to next message
Mayte Restrepo is currently offline  Mayte Restrepo
Messages: 2
Registered: February 2020
Member
Hi Sofia,

I was wondering if you received any answer to your question about municipality codes for the 1990-2000 Colombia DHS.

Thank you,
Mayte
Re: Merging DHS data sets with DANE municipality codes [message #18813 is a reply to message #18812] Tue, 25 February 2020 16:21 Go to previous messageGo to next message
ren_sof is currently offline  ren_sof
Messages: 4
Registered: January 2019
Member
Hi Mayte,

No, unfortunately I did not.

Regards,

Oriana.
Re: Merging DHS data sets with DANE municipality codes [message #18814 is a reply to message #18813] Tue, 25 February 2020 18:25 Go to previous messageGo to next message
tfish-DHS is currently offline  tfish-DHS
Messages: 48
Registered: August 2017
Location: Maryland, USA
Member
Hi all,

We do not maintain keys to match district codes or municipality codes to the names of districts or municipality codes

best,

--Tom
Re: Merging DHS data sets with DANE municipality codes [message #23372 is a reply to message #16555] Mon, 30 August 2021 12:53 Go to previous message
kadam020@uga.edu is currently offline  kadam020@uga.edu
Messages: 8
Registered: April 2020
Member
Hi Sofia,

I had a question about merging DANE and DHS municipality datasets. Were you able to match the municipality codes of DANE with DHS? I am working with the 2005 census municipality codes from DANE and trying to merge the 2010 DHS women's survey using municipality codes (created by concatenating department and municipality), but the codes of the two sources seem very different and I have not been able to match them! I already asked on the forum as a separate query but I have not received any response yet, thus, I would appreciate any help from you regarding this issue, thanks!

Previous Topic: Correct district - Uganda 2016 Male Sample
Next Topic: Merging survey data to geographic dataset
Goto Forum:
  


Current Time: Thu Mar 28 04:59:23 Coordinated Universal Time 2024