The DHS Program User Forum: Weighting data » Ratio of girls to boys in a family

Home » Data » Weighting data » Ratio of girls to boys in a family

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

Re: Ratio of girls to boys in a family [message #16571 is a reply to message #16559]

Tue, 29 January 2019 08:12

Bridgette-DHS
Messages: 3214
Registered: February 2013

Senior Member

Following is a response from Senior DHS Stata Specialist, Tom Pullum:

There are two ways to do this. The easy way is with the first two lines below. The second way is to loop through the b variables, as you were trying to do. The last three lines will confirm that you get the same results with both methods.

gen boys1=v202+v204+v206
gen girls1=v203+v205+v207

ren b*_0* b*_*
local li=1
while `li'<=20 {
gen boy_`li'=1 if b4_`li'==1
gen girl_`li'=1 if b4_`li'==2
local li=`li'+1
}

egen boys2=rowtotal(boy_*)
egen girls2=rowtotal(girl_*)

correlate boys*
correlate girls*
summarize boys* girls*

[Updated on: Tue, 29 January 2019 08:18]

Report message to a moderator

[Message index]

		Ratio of girls to boys in a family By: sumonrupop on Fri, 25 January 2019 23:27
		Re: Ratio of girls to boys in a family By: Bridgette-DHS on Tue, 29 January 2019 08:12

Previous Topic:	Weighting between DHS and non DHS surveys
Next Topic:	Using weights for merged PR&IR file NFHS-4(2015-16), India

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Thu Dec 19 14:13:51 Coordinated Universal Time 2024