The DHS Program User Forum - RDF feed
https://userforum.dhsprogram.com/index.php
cluster average of women's working status
https://userforum.dhsprogram.com/index.phpindex.php?t=rview&goto=13800&th=6672#msg_13800
I would like to develop a variable that the percentage of working women at the cluster level excluding the woman's own working status or I shall call it the cluster average of women's working status. I would be very grateful if you can share STATA codes.]]>ahmed89o2017-12-28T12:52:59-00:00Re: cluster average of women's working status
https://userforum.dhsprogram.com/index.phpindex.php?t=rview&goto=13803&th=6672#msg_13803
I think this is a question for the Stata forum - but one suggestion would be to use "egen , by()" commands. I'm assuming you have 0/1 variables for "working". In that case, first, compute the cluster-level denominator, which is N for that cluster (I think). Then generate the cluster-level numerator by adding up the 0's and 1's in the cluster for everyone. Then, for each person, use as the numerator "total - own" and for the denominator "total - 1".
Something like that should work...but again, the Statalist may be a better resource for you.]]>Reduced-For(u)m2017-12-28T20:55:22-00:00