The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Topics » General » Aggregating up to district level in NFHS-4
Re: Aggregating up to district level in NFHS-4 [message #20386 is a reply to message #20319] Mon, 26 October 2020 17:58 Go to previous message
Bridgette-DHS is currently offline  Bridgette-DHS
Messages: 2402
Registered: February 2013
Senior Member

Following is a response from DHS Research & Data Analysis Director, Tom Pullum:

I don't know which file you want to use, but let's say it's the PR file (IAPR74FL.dta). In that file, district is given by shdistri. The numerical codes for the names will be given if you enter "label list SHDISTRI". In your district-level file, be sure that the district ID has the same name and the same codes. Sort that file by shdistri and save it. Then open the PR file and sort it by shdistri. Then merge with the saved district-level file. There are many examples of merges on the forum.

This will attach the district-level variables to the individual cases in the PR file. You can then treat those variables as covariates. You can collapse the file (try "help collapse") but that's not necessary. Ideally, you would do the analysis with multi-level models.
Read Message
Read Message
Previous Topic: Question of STATA
Next Topic: Merge Service Availability data with individual data for zimbabwe
Goto Forum:

Current Time: Tue Oct 19 11:46:54 Coordinated Universal Time 2021