The DHS Program User Forum: Weighting data » Sex ratio at 2nd birth order

Home » Data » Weighting data » Sex ratio at 2nd birth order

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

Re: Sex ratio at 2nd birth order [message #27354 is a reply to message #27351]

Tue, 25 July 2023 13:04

Bridgette-DHS
Messages: 3151
Registered: February 2013

Senior Member

Following is a response from Senior DHS staff member, Tom Pullum:

The following Stata program, which can be used with any IR file, calculates a new set of variables giving the sex of the child indexed by birth order rather than bidx (which is 1 for the most recent birth, etc.). It can be modified to be more general, if desired, to index any or all of the b variables by birth order rather than bidx.

use "...IAIR7EFL.DTA", clear

* Recode the b variables so they are indexed by bord rather than bidx
* Illustrated for just b4, sex of the child

* Based on the relationship bidx+bord=v201+1

rename *_0* *_*

* construct a new variable, sex, that is b4 indexed by bord rather than bidx

forvalues lceb=1/20 {
gen sex_`lceb'=.
quietly forvalues lbord=1/`lceb' {
local lbidx=`lceb'+1-`lbord'
replace sex_`lbord'=b4_`lbidx' if v201==`lceb'
}
}

tab1 sex_*
tab sex_2 sex_1 [iweight=v005/1000000],col

Report message to a moderator

[Message index]

		Sex ratio at 2nd birth order By: Kanika on Mon, 24 July 2023 13:36
		Re: Sex ratio at 2nd birth order By: Kanika on Mon, 24 July 2023 16:13
		Re: Sex ratio at 2nd birth order By: Bridgette-DHS on Tue, 25 July 2023 13:04

Previous Topic:	Inconsistencies in v022, v024 and Appendix A Tables
Next Topic:	Problem Generating A_h; M_h & M

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Mon Sep 9 00:15:44 Coordinated Universal Time 2024