The DHS Program User Forum - RDF feed
https://userforum.dhsprogram.com/index.php
Merging DHS data sets with municipality information
https://userforum.dhsprogram.com/index.phpindex.php?t=rview&goto=14330&th=6878#msg_14330
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 ]]>clotilde.mahe2018-03-23T09:15:23-00:00Re: Merging DHS data sets with municipality information
https://userforum.dhsprogram.com/index.phpindex.php?t=rview&goto=14333&th=6878#msg_14333
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.]]>Bridgette-DHS2018-03-23T23:10:00-00:00Re: Merging DHS data sets with municipality information
https://userforum.dhsprogram.com/index.phpindex.php?t=rview&goto=14336&th=6878#msg_14336
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
]]>clotilde.mahe2018-03-25T07:06:21-00:00Re: Merging DHS data sets with municipality information
https://userforum.dhsprogram.com/index.phpindex.php?t=rview&goto=14348&th=6878#msg_14348
Bridgette-DHS2018-03-26T18:22:43-00:00Re: Merging DHS data sets with municipality information
https://userforum.dhsprogram.com/index.phpindex.php?t=rview&goto=14352&th=6878#msg_14352
Best regards,
Clotilde ]]>clotilde.mahe2018-03-27T05:23:44-00:00Re: Merging DHS data sets with municipality information
https://userforum.dhsprogram.com/index.phpindex.php?t=rview&goto=20167&th=6878#msg_20167
castle2020-10-05T02:48:14-00:00Re: Merging DHS data sets with municipality information
https://userforum.dhsprogram.com/index.phpindex.php?t=rview&goto=24062&th=6878#msg_24062
bellabillig2022-02-15T17:48:06-00:00Re: Merging DHS data sets with municipality information
https://userforum.dhsprogram.com/index.phpindex.php?t=rview&goto=24070&th=6878#msg_24070
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.]]>Bridgette-DHS2022-02-17T14:59:09-00:00Re: Merging DHS data sets with municipality information
https://userforum.dhsprogram.com/index.phpindex.php?t=rview&goto=26313&th=6878#msg_26313
I am still unable to get the DANE municipality codes for DHS 1995 or 2000 using the instructions provided (using shmunip and shdepto). I understand this is an old thread, but any idea if it is possible to get these from these DHS rounds for Colombia? For both 1995 and 2000, the shmunip variable takes on values from 1 to 61- which, after concatenating with the department will not yield the desired DANE municipality codes.
I would hugely appreciate the help!
Thanks and regards,
Manhar]]>manhar2023-03-07T14:46:46-00:00Re: Merging DHS data sets with municipality information
https://userforum.dhsprogram.com/index.phpindex.php?t=rview&goto=26317&th=6878#msg_26317
Following is a response from Senior DHS staff member, Tom Pullum:
Guillermo Rojas first told you on March 23, 2018, almost 5 years ago, that in the 2015 survey the code is given by code=1000*shdepto + shmunip; the code is calculated similarly in all other surveys except 1995; and the information to calculate the code in the 1995 survey is unfortunately absent. Variable names such as "shdepto" and "shmunip", beginning with "sh", are in the HR and PR files. The variable names may begin with other prefixes in other files and the variable names may be different in other surveys. We (DHS staff) have nothing to add to this. Perhaps some other users can help.]]>Bridgette-DHS2023-03-07T18:02:36-00:00