The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Data » Dataset use in Stata » Multilevel analysis-Pakistan DHS (Individual and community level variable affecting Skilled birth attendance in Pakistan)
Multilevel analysis-Pakistan DHS [message #19133] Fri, 24 April 2020 04:38 Go to next message
saifulhaq is currently offline  saifulhaq
Messages: 2
Registered: October 2019
Member
Hello,
I am a research student and i am working on my thesis titled " individual and community level socioeconomic associates of Skilled birth attendance in Pakistan". i am using DHS data on STATA software fo this purpose. Can anyone please guide me on how to create community level variable form individual level variables using DHS data on STATA.


Best,


Saif
Pakistan
Re: Multilevel analysis-Pakistan DHS [message #19298 is a reply to message #19133] Fri, 22 May 2020 06:52 Go to previous message
Frankfeng is currently offline  Frankfeng
Messages: 5
Registered: September 2019
Member
Hi,

I have not use DHS to create community level before, but I have some experience to create community level variable form individual level variables using other datasets on STATA.

1. You can use cross-tab to get the proportion of individual level variables by community if individual level variables are categorical variables. For example, tab community eduction, you will get the proportion of illiteracy/higher education for each community. Copy those results from STATA and then create a new dataset with all community level variables you want and merge it back to the original one (use merge m:1). I would suggest that you use weight in the cross-tab that may be less bias.

2.You can use bysort to get the mean/median or any other infomation of individual level variables by community if individual level variables are continuous variables. And then again create a new dataset with all community level variables you want. This may cost you time to copy and paste infomration for each community. You then can merge it back to the original one.

I hope this helps.
Previous Topic: Estimating preterm birth
Next Topic: 2017 Ghana Maternity and Health Survey abortion calculation
Goto Forum:
  


Current Time: Sun Jun 7 03:05:11 Eastern Daylight Time 2020