Home » Data » Dataset use in SPSS » Prevalence of disability and associated risk factors
Prevalence of disability and associated risk factors [message #10628] 
Mon, 22 August 2016 04:55 
npolle
Messages: 6 Registered: August 2016 Location: MOMBASA, KENYA

Member 


I am a beginner in using DHS data. I am interested in using the 2011 Uganda Demographic and Health Survey to determine prevalence of disability and associated risk factors. I have been able to produce similar descriptive statistics to that presented in the final report when using the women and men recode files for example in table 3.1. However when using the Household file (where data on disability is) the statistics i generate are slightly higher (table 2.14). kindly assist.
Secondly can i use the the variable V025 as the strata variable (since V023 and v022 have missing values) when adjusting for complex survey design. This was suggested in one of the forums. Thank you.





Re: Prevalence of disability and associated risk factors [message #10655 is a reply to message #10650] 
Fri, 26 August 2016 07:22 
BridgetteDHS
Messages: 3094 Registered: February 2013

Senior Member 


Another response from Tom Pullum:
The command in Stata to get the percentage distribution for sh24 in table 2.14, and the total of 35,226 is the following:
use UGPR60FL.dta
tab sh24 [iweight=hv005/1000000] if hv105>=5 & hv105<96 & hv103==1
Here I am excluding cases with hv105>=96, which are basically missing on age. This gives a total of 35,226 weighted cases. Same for sh25 through sh29.
I cannot tell you how to construct a stratum variable in SPSS, because I do not use SPSS. In Stata it would be egen stratum=group(hv024 hv025). Here is another way to do it that does not use egen and group, which are strictly Stata commands.
If you do "tab hv024 hv025" you will see that there are 10 regions and 2 places of residence. There are not 20 combinations, however, because Kampala is completely urban. There are 19. Try this (translated to Stata): "gen stratum=hv024+9*(hv0251)". There are other ways to do a recode, but this will give the urban parts of the regions as strata 110 and the rural parts, excluding Kampala, as 1119.




Goto Forum:
Current Time: Sun Jun 23 03:36:25 Coordinated Universal Time 2024
