The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Data » Merging data files » Merging DHS data sets with municipality information
Merging DHS data sets with municipality information [message #14330] Fri, 23 March 2018 05:15 Go to next message
clotilde.mahe is currently offline  clotilde.mahe
Messages: 3
Registered: March 2018
Member
Dear all,

I would like to merge municipality information for a different source with the different DHS data sets (for 1995, 2000, 2005 and 2010 DHS waves for Colombia). However, I am having difficulties understanding which variable(s) give the municipality number in the DHS data sets. 'smunip' is a code from 1 to 61, specific to the DHS for surveyed municipalities that cannot be used with the official (DANE) used to code municipalities... The variable giving information on the primary sampling area (a municipality according to the report of 1995) ('smuest', if I am not mistaken) contains much more unique observations than the sampled number of municipalities (61)... Is there a way to obtain the DANE code of municipalities in the DHS data sets so that I could merge information on municipalities from another source?

Thank you for your consideration and help.

Clotilde

[Updated on: Fri, 23 March 2018 05:15]

Report message to a moderator

Re: Merging DHS data sets with municipality information [message #14333 is a reply to message #14330] Fri, 23 March 2018 19:10 Go to previous messageGo to next message
Bridgette-DHS is currently offline  Bridgette-DHS
Messages: 2589
Registered: February 2013
Senior Member
Following is a response from DHS Chief of Data Processing, Guillermo Rojas:

Municipality code in Colombia can be constructed by concatenating "Departamento" and "Municipality". In DHS-7 variables SHDEPTO and SHMUNIP should be used for this purpose, in other rounds there are similar variables to be used. For example, If SHDEPTO = 15 (Boyaca) and SHMUNIP = 1 it will give the code 15001 which corresponds to the capital of that Department (Tunja) . This concatenated code is the code used by the Colombian statistical office (DANE). I know that there is at least one round where this codification schema was not used, but if required we can dig up the code.
Re: Merging DHS data sets with municipality information [message #14336 is a reply to message #14333] Sun, 25 March 2018 03:06 Go to previous messageGo to next message
clotilde.mahe is currently offline  clotilde.mahe
Messages: 3
Registered: March 2018
Member
Hello,

Thank you very much for your reply. I managed to obtain this concatenated code for municipalities for the 1986, 1990, 2005, 2010 and 2015 waves following your advice. However, I could not for the 1995 and 2000 as the 'smunip' is a code from 1 to 61, specific to the DHS for surveyed municipalities that cannot be used with the official (DANE) used to code municipalities... Could you please help me in obtaining/explaining me how to obtain the municipality code used by the Colombian statistical office in the 1995 and 2000 waves?

Thank you for your consideration.

Clotilde
Re: Merging DHS data sets with municipality information [message #14348 is a reply to message #14336] Mon, 26 March 2018 14:22 Go to previous messageGo to next message
Bridgette-DHS is currently offline  Bridgette-DHS
Messages: 2589
Registered: February 2013
Senior Member
We have sent a reply to the email address you registered on the Forum. Thanks for using DHS data.
Re: Merging DHS data sets with municipality information [message #14352 is a reply to message #14348] Tue, 27 March 2018 01:23 Go to previous messageGo to next message
clotilde.mahe is currently offline  clotilde.mahe
Messages: 3
Registered: March 2018
Member
Thank you very much for your help in this!

Best regards,

Clotilde
Re: Merging DHS data sets with municipality information [message #20167 is a reply to message #14352] Sun, 04 October 2020 22:48 Go to previous messageGo to next message
castle
Messages: 2
Registered: March 2016
Location: Colombia
Member
Hi Matilde: Could you please explain to me how to obtain the municipality code used by the Colombian statistical office in 2000 waves? Thanks in advance.
Re: Merging DHS data sets with municipality information [message #24062 is a reply to message #14333] Tue, 15 February 2022 12:48 Go to previous messageGo to next message
bellabillig is currently offline  bellabillig
Messages: 1
Registered: February 2022
Member
Hello! I am having an issue with this same problem. I could concatenate the departments and municipalities to match the DANE codes, but it is only working for 1986 data. I would appreciate it if you could send me an email or respond on here to explain the code for the other years. Thank you!
Re: Merging DHS data sets with municipality information [message #24070 is a reply to message #24062] Thu, 17 February 2022 09:59 Go to previous message
Bridgette-DHS is currently offline  Bridgette-DHS
Messages: 2589
Registered: February 2013
Senior Member

Following is another response from DHS Chief of Data Processing, Guillermo Rojas:

The instructions I gave before work correctly for all DHS rounds in Colombia (including DHS 2000). The only one that has a different coding schema is 1995 and unfortunately I couldn't find the municipality codes for that round. At that time there were limitations on how many codes (categories) could be stored in dictionaries for variables.
Previous Topic: merging data
Next Topic: Merging MR and PR file for India
Goto Forum:
  


Current Time: Tue Oct 4 05:40:09 Coordinated Universal Time 2022