I want to use DHS of 1987 for anthropometric measurements.

Who can help for the stata code for results by province or by region?

As I have a dataset on Height and Weight Scores - WHO Child Growth Standards (BUHW01FL.dta)with 'hwcaseid' var., how can merge this dataset with the one of the household raw?

Many thanks for your help.

Tharcisse]]>

The following code will link the two together:

* rename variables and sort data for merging use "BUHW01FL.DTA", clear ren hwcaseid caseid ren hwline midx sort caseid midx save "BUHW01_temp.dta", replace * Sort the children's recode data and then merge use "BUKR01FL.DTA", clear sort caseid midx merge 1:1 caseid midx using "BUHW01_temp.dta" * Example tabulation of stunted by region gen stunted = (hc70<-200) if hc70 <9990 tab v101 stunted [iw=v005/1000000]

Many thanks for your reply.

When using the stata code sent, I do not have the same total number of children as the technical report.

I find in total 1,917.81 instead 1929.5 children in the report.

a) What should be the causes of this discrepancy?

b) Is it possible to merge my new dataset "BUHW01_temp.dta" with the the one with the household(Hhs) characteristics "BUHH01FL.dta"?

This will help me to figure out the main characteristics of the Hhs where children are stunted.

Many thanks and kind regards,

Tharcisse]]>

many thanks for your feed-back.

Tharcisse]]>

* Drop merge variable from previous run drop _merge * Copy cluster and household variables clonevar hhseg=v001 clonevar hhrugo=v002 * Merge data merge m:1 hhseg hhrugo using "BUHH01FL.dta", keep(match)

]]>

Thank you very much for this response of my second question. I will try to use this and will come to you if necessarly.

As I want to analyse the changes from 1987 to 2010, do I have to do the same exercise to retrieve anthropometric measures (Stunted, Wasted and underweigthed children)for DHS2010? I mean do I have to merge children data set with the one of Households (Hhs) in order to assess the characteristics of Hhs where there are severe stunting, wasting and underweighted children?

Thanks for your help.

Regards,

Tharcisse ]]>

You forget to attach the tabulation you talked about in your previous response:

"The 1929 cases are based on using the old CDC/NCHS/WHO reference, not the WHO standard from 2006. If you use hw4 (from the old reference) instead of hc70 (based on WHO 2006 standard) in the tabulation below, you will get 1929 cases." message of Mon, 10 November 2014 17:15.

I didn't find any tabulation to be used with hw4 instead hc70.

Can I use the same formulation for wasted and under-weighted children?

Many thanks,

Tharcisse

]]>

]]>

Many thanks for this useful information.

Will come to you if necessary,

Kind regards,

Tharcisse]]>

I an struggling trying to find out a variable in DHS1987 (Burundi) which is similar to 'v023'= 'stratification used in sample design' recoded in Burundi DHS2010. Do you have any suggestion so that I can make my trend analysis in terms of province (administrative level 2)?

Regards,

Tharcisse]]>

egen v023 = group(v102 v101)

This will create strata formed by cross classifying the 5 regions by the urban and rural areas and will result in two urban strata plus the five rural groups as strata.]]>

Many thanks for your reply.

So, that means it is impossible to retrieve a variable relate on provinces instead regions(11) and urban/rural.

Best regards,

Tharcisse]]>

I am struggling trying to merge data sets (HR, household) and (KR, children) in DHS2010 for Burundi. I tried many times but still have this in my results:

"variables v001 v002 do not uniquely identify observations in the master data" Can you tell me how you come up with your problem ?

Here is my codes:

*************************************

use "BUHR61FL.DTA", clear

ren hv001 v001

ren hv002 v002

sort v001 v002

save "BUHW6FL_temp.dta", replace

use "BUKR61FL.DTA", clear

sort v001 v002

merge 1:1 v001 v002 using "BUHW6FL_temp.dta"

drop _merge

save "BUHW6FL_BUKR6FL.dta", replace

************************************************************ *****

Many thanks in advance,

Tharcisse ]]>

I will need to do the same exercise for Rwanda (2010), Tanzania (2010), Kenya (2008-2009) and Uganda (2011)

many thanks for you help!

Regards,

Tharcisse]]>

1 - this is not a 1:1 merge - there are often more than one child in each household. Try m:1 or 1:m, depending on which one you start with. There is help here:

http://www.stata.com/help.cgi?merge

2 - what variables do you need from the HH file that are not in the child recode?]]>

merge m:1 v001 v002 using "BUHW6FL_temp.dta"

in the example you give below as there are potentially multiple children from each household.]]>