The DHS Program User Forum: Dataset use in Stata » Dealing with country-specific codes with panel data across 10 countries

Home » Data » Dataset use in Stata » Dealing with country-specific codes with panel data across 10 countries

Show: Today's Messages :: Show Polls :: Message Navigator

Re: Dealing with country-specific codes with panel data across 10 countries [message #10415 is a reply to message #10413]

Tue, 26 July 2016 10:46

Bridgette-DHS
Messages: 3230
Registered: February 2013

Senior Member

Following is a response from Senior DHS Stata Specialist, Tom Pullum:

What you are describing is indeed very time consuming. We had to do much the same thing for Methodological Report 15 in 2014 (https://www.dhsprogram.com/pubs/pdf/MR15/MR15.pdf). There are probably many ways to approach it, but we did it as follows.

The first attachment is an excel file with one sheet for each country. The sheets have columns for the successive surveys and panels for the variables. The final column of the sheet is a "harmonized" coding. We were working with the HR files, with one record per household. You would probably be using the IR or KR files, but that would make little difference in the steps..

The second attachment is a Stata program I wrote to do the recoding. Basically it converts the excel sheets into recode instructions for every variable and every file. It's not a simple program but there are lots of comments. Hope you can figure out the logic--I can't provide much support beyond this. Good luck!

Attachment: Copy of Harmonizing data-20140424.xlsx
(Size: 382.16KB, Downloaded 814 times)
Attachment: CWI_recoding_do_3June2014.txt
(Size: 11.93KB, Downloaded 1125 times)

Report message to a moderator

[Message index]

		Dealing with country-specific codes with panel data across 10 countries By: jane_cheatley on Tue, 26 July 2016 09:52
		Re: Dealing with country-specific codes with panel data across 10 countries By: Bridgette-DHS on Tue, 26 July 2016 10:46
		Re: Dealing with country-specific codes with panel data across 10 countries By: jane_cheatley on Wed, 27 July 2016 08:35
		Re: Dealing with country-specific codes with panel data across 10 countries By: jane_cheatley on Mon, 01 August 2016 05:00
		Re: Dealing with country-specific codes with panel data across 10 countries By: Bridgette-DHS on Mon, 01 August 2016 08:08
		Re: Dealing with country-specific codes with panel data across 10 countries By: kingx025 on Sun, 08 July 2018 20:15

Previous Topic:	Discrepancy in stunting, wasting, underweight prevalence for Nepal DHS 2001
Next Topic:	Antibiotic use for ARI - Tanzania DHS 2016

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Wed Aug 13 20:21:55 Coordinated Universal Time 2025