The DHS Program User Forum - RDF feed
https://userforum.dhsprogram.com/index.php
Aggregating up to district level in NFHS-4
https://userforum.dhsprogram.com/index.phpindex.php?t=rview&goto=20319&th=9407#msg_20319
I am trying to merge the NFHS-4 dataset with another dataset that contains variables at the district-level. Are there district weights somewhere in the NFHS-4 dataset that will allow me to aggregate up the individual-level responses to the district level? Has someone else done this and knows how to do it in Stata?
Thank you!]]>zoeg2020-10-22T13:27:18-00:00Re: Aggregating up to district level in NFHS-4
https://userforum.dhsprogram.com/index.phpindex.php?t=rview&goto=20386&th=9407#msg_20386
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.
]]>Bridgette-DHS2020-10-26T21:58:17-00:00