Home » Topics » Child Health » Replicating DHS tables on child health
Re: Replicating DHS tables on child health [message #8703 is a reply to message #8667] |
Thu, 03 December 2015 11:55 |
Trevor-DHS
Messages: 802 Registered: January 2013
|
Senior Member |
|
|
1a) M18 in the KR file contains the size at birth variable. For size at birth you first need to merge UGKR60FL.DTA to UGPR60FL.DTA. First sort the PR file on hv001 hv002 and hvidx, and the KR file on v001 v002 and b16. Drop cases from the KR file that have b16 == 0 or 99 or missing (.) as these are children that do not live in the household, died, or had other missing data. Then perform a 1:1 merge.
1b) For mother's interview status, you need to look at hv111 and hv112, and then for cases where hv112 is not 0, 99, or missing (.) you need to merge the IR file to see if the mother was successfully interviewed. Use hv001 hv002 and hv112 from the PR file and v001 v002 and v003 from the IR file for the merge. This should be a many to one (m:1) merge from the PR file using the IR file as the mother may have had more than one child. Note that you will need to sort on the above fields first before merging.
1c) For mother's nutritional status, you need to use HA40 for the mother. This get's trickier as you already have an ha40 in the child's record, but it will be blank. You will need to drop this variable, and then merge in ha40 for the mother from another copy of the PR file. To do this, you will need:
- your PR file sort based on hv001 hv002 and hv112, and with ha40 dropped. gen mother=hv112
- a copy of the original PR file sorted on hv001 hv002 and hvidx. gen mother=hvidx
You will then merge 1:1 using hv001 hv002 and mother, and just add ha40 from the copy of the PR file to your main PR file.
2) For the preceding birth interval, once you have done the merge of the KR file in the first step above, then just use B11. B11 is set to missing for first births, so just recode the durations into the groups you need and the missing (.) to the category for first birth.
|
|
|
|
|
Replicating DHS tables on child health
By: lexgw on Mon, 16 November 2015 19:00
|
|
|
Re: Replicating DHS tables on child health
|
|
|
Re: Replicating DHS tables on child health
By: lexgw on Wed, 18 November 2015 07:41
|
|
|
Re: Replicating DHS tables on child health
By: lexgw on Wed, 18 November 2015 18:47
|
|
|
Re: Replicating DHS tables on child health
By: lexgw on Thu, 26 November 2015 17:46
|
|
|
Re: Replicating DHS tables on child health
|
|
|
Re: Replicating DHS tables on child health
|
|
|
Re: Replicating DHS tables on child health
|
|
|
Re: Replicating DHS tables on child health
By: lexgw on Thu, 19 November 2015 09:32
|
|
|
Re: Replicating DHS tables on child health
By: lexgw on Thu, 19 November 2015 20:07
|
|
|
Re: Replicating DHS tables on child health
|
|
|
Re: Replicating DHS tables on child health
By: lexgw on Sat, 21 November 2015 05:55
|
|
|
Re: Replicating DHS tables on child health
|
|
|
Re: Replicating DHS tables on child health
By: lexgw on Sat, 21 November 2015 21:12
|
|
|
Re: Replicating DHS tables on child health
|
|
|
Re: Replicating DHS tables on child health
By: lexgw on Mon, 23 November 2015 09:22
|
|
|
Re: Replicating DHS tables on child health
|
|
|
Re: Replicating DHS tables on child health
By: lexgw on Mon, 23 November 2015 10:56
|
|
|
Re: Replicating DHS tables on child health
|
|
|
Re: Replicating DHS tables on child health
By: lexgw on Mon, 23 November 2015 11:00
|
|
|
Re: Replicating DHS tables on child health
By: lexgw on Mon, 23 November 2015 11:05
|
|
|
Re: Replicating DHS tables on child health
|
|
|
Re: Replicating DHS tables on child health
|
|
|
Re: Replicating DHS tables on child health
By: lexgw on Mon, 23 November 2015 11:16
|
|
|
Re: Replicating DHS tables on child health
|
|
|
Re: Replicating DHS tables on child health
By: lexgw on Thu, 10 December 2015 08:35
|
|
|
Re: Replicating DHS tables on child health
By: lexgw on Thu, 10 December 2015 09:23
|
|
|
Re: Merging
By: lexgw on Thu, 04 August 2016 13:36
|
|
|
Re: Merging
|
|
|
Re: Merging
By: lexgw on Fri, 05 August 2016 20:25
|
Goto Forum:
Current Time: Sat Nov 2 00:14:11 Coordinated Universal Time 2024
|