The DHS Program User Forum: General » Aggregating up to district level in NFHS-4

Home » Topics » General » Aggregating up to district level in NFHS-4

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

Re: Aggregating up to district level in NFHS-4 [message #20386 is a reply to message #20319]

Mon, 26 October 2020 17:58

Bridgette-DHS
Messages: 3216
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.

Report message to a moderator

[Message index]

		Aggregating up to district level in NFHS-4 By: zoeg on Thu, 22 October 2020 09:27
		Re: Aggregating up to district level in NFHS-4 By: Bridgette-DHS on Mon, 26 October 2020 17:58

Previous Topic:	Question of STATA
Next Topic:	Merge Service Availability data with individual data for zimbabwe

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Sun Jan 5 18:05:19 Coordinated Universal Time 2025