The DHS Program User Forum: Ethiopia » matching data with the report

Home » Countries » Ethiopia » matching data with the report

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

Re: matching data with the report [message #15113 is a reply to message #15089]

Tue, 05 June 2018 07:50

Bridgette-DHS
Messages: 1806
Registered: February 2013

Senior Member

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

I can only say how we do this in Stata. Open the KR file (ETKR70FL.dta) and paste the following lines into the command window:

* restrict to children living with the mother
keep if b9==0

* the youngest child will be the one with the lowest value of bidx
sort v001 v002 v003 bidx
egen sequence=seq(), by(v001 v002 v003)

tab sequence bidx,m
keep if sequence==1

Stata has some "egen" ("extensions to generate") commands that are very helpful. This one, "seq()", as used here, will sequence the children who have the same mother (identified with v001 v002 v003) in the order of bidx. This is used AFTER the KR file has been reduced to children who are living with the mother (no need to do a separate check on whether they are alive), given with b9=0. If SPSS does not have a command similar to seq(), you will have to find some other way to do this. Perhaps another SPSS user can help.

Report message to a moderator

[Message index]

		matching data with the report By: Fana on Tue, 08 May 2018 11:49
		Re: matching data with the report By: Bridgette-DHS on Wed, 23 May 2018 13:37
		Re: matching data with the report By: sadya2018@gmail.com on Thu, 24 May 2018 21:58
		Re: matching data with the report By: Fana on Thu, 31 May 2018 09:26
		Re: matching data with the report By: Bridgette-DHS on Tue, 05 June 2018 07:50
		Re: matching data with the report By: abebe on Sun, 14 April 2019 19:22
		Re: matching data with the report By: Bridgette-DHS on Fri, 26 April 2019 10:37
		Re: matching data with the report By: abebe on Fri, 26 April 2019 11:46
		Re: matching data with the report By: abebe on Wed, 22 May 2019 19:16
		Re: matching data with the report By: Bridgette-DHS on Sun, 16 June 2019 06:33
		Re: matching data with the report By: Bridgette-DHS on Tue, 18 June 2019 16:33

Previous Topic:	Anthropometry_Ethiopia_2011DHS
Next Topic:	SPA data set related question

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Thu Jul 2 18:30:32 Eastern Daylight Time 2020