|
Re: Survival Status in Stata [message #10963 is a reply to message #10962] |
Thu, 13 October 2016 07:28 ![Go to previous message Go to previous message](/theme/default/images/up.png) |
Bridgette-DHS
Messages: 3151 Registered: February 2013
|
Senior Member |
|
|
Following is a response from Senior DHS Stata Specialist, Tom Pullum:
Quote:Here are some Stata lines that will put successive children onto the same record. I have set it up for the BR file for a Malawi survey but you could use either the BR or KR file for any survey. You can use b5 for the older child in the pair or do any other comparisons between the two children. You have to give different names to the variables for the older child, as I show for the b variables. Let me know if you have questions.
* How to put the next older child (if any) onto a child's record
* Strategy: construct a variable "pair" that has the same value for the younger and older child;
* save one copy of the file for the younger child and another copy for the older child and then merge.
set more off
* specify a folder for temporary files
cd e:\DHS\DHS_data\scratch
* open a BR file; could also do with a KR file
use e:\DHS\DHS_data\BR_files\MWBR61FL.dta
keep v001 v002 v003 b*
* bidx=1 for the youngest child
gen pair=bidx
sort v001 v002 v003 pair
save temp.dta, replace
drop if bidx==1
gen pair=bidx-1
rename b* older_b*
sort v001 v002 v003 pair
merge v001 v002 v003 pair using temp.dta
* check by testing whether the birth interval matches with b11 for the younger child and b12 for the older child
gen interval=b3-older_b3
correlate interval b11 if interval>0
correlate interval older_b12 if interval>0
|
|
|