DHS Burundi 1987 [message #3202] |
Thu, 06 November 2014 09:15 |
tnkunzimana
Messages: 14 Registered: November 2014 Location: Italy
|
Member |
|
|
Dear all,
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
Tharcisse Nkunzimana
Agricultural Economist
Scientific Officer/Food and Nutrition Security
|
|
|
|
Re: DHS Burundi 1987/ another REQUEST [message #3227 is a reply to message #3219] |
Mon, 10 November 2014 07:53 |
tnkunzimana
Messages: 14 Registered: November 2014 Location: Italy
|
Member |
|
|
Dear Trevor-DHS,
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
Tharcisse Nkunzimana
Agricultural Economist
Scientific Officer/Food and Nutrition Security
|
|
|
|
|
|
|
|
|
|
|
|
DHS Burundi 1987 and 2010 [message #3304 is a reply to message #3243] |
Wed, 19 November 2014 14:29 |
tnkunzimana
Messages: 14 Registered: November 2014 Location: Italy
|
Member |
|
|
Dear Trevor-DHS,
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
Tharcisse Nkunzimana
Agricultural Economist
Scientific Officer/Food and Nutrition Security
|
|
|
|
|
|
Re: DHS Burundi 1987 and 2010 [message #3923 is a reply to message #3370] |
Fri, 06 March 2015 13:32 |
tnkunzimana
Messages: 14 Registered: November 2014 Location: Italy
|
Member |
|
|
Dear Trevor-DHS,
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
Tharcisse Nkunzimana
Agricultural Economist
Scientific Officer/Food and Nutrition Security
|
|
|
Re: DHS Burundi 1987 and 2010 [message #3924 is a reply to message #3923] |
Fri, 06 March 2015 13:36 |
tnkunzimana
Messages: 14 Registered: November 2014 Location: Italy
|
Member |
|
|
Dear Trevor-DHS,
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
Tharcisse Nkunzimana
Agricultural Economist
Scientific Officer/Food and Nutrition Security
|
|
|
|
|
|
|
|
|
|
|
|
Re: DHS Burundi 1987 [message #20176 is a reply to message #20175] |
Mon, 05 October 2020 18:17 |
Trevor-DHS
Messages: 805 Registered: January 2013
|
Senior Member |
|
|
I think you are misunderstanding the data. In all of the surveys that you are using the anthropometry data were collected for children listed in the household schedule (the PR file). For the earlier surveys (2000 and 2005), for which you need to use the HW files, the WHO growth standards did not exist at the time of those surveys, and so these HW files were constructed later. These HW data files are designed to be used with the PR file, and include the hc7* series of variables. These variables already exist if the PR file for the later surveys (2011 and 2016). If you wish to analyze anthropometry we recommend using the PR file.
The KR files include the hw7* series of variables which are a copy of the hc7* series of variables from the PR file, but restricted just to children of interviewed women. Thus analyzing anthropometry using the KR file will give you somewhat biased estimates as it is only based on children of women interviewed, and thus likely excludes orphaned and fostered children. Thus we recommend using the PR file.
Why do you need to restrict your analysis just to children of interviewed women?
If you do need to restrict your analysis and need to use the KR file, then, yes, you can rename hc7* to hw7* when you merge the data.
|
|
|
|
Re: DHS Burundi 1987 [message #20182 is a reply to message #20180] |
Tue, 06 October 2020 13:10 |
Trevor-DHS
Messages: 805 Registered: January 2013
|
Senior Member |
|
|
Thanks - that makes sense. I just wanted to make sure that you were using the KR file for a good reason.
Weighting is applied when you analyze the data after you have pooled the data. Note that you cannot just combine the datasets and use them as they are with the weights given for each survey as the probability of selection of a woman in each survey varies. You need to adjust the weighting to take into account that the probability of selection differed. The sample sizes for the surveys were:
Year : Sample : Total women 15-49* : Probability of selection
2000 : 15367 : 14,619,000 : 1 in 951.324
2005 : 14070 : 16,861,000 : 1 in 1198.365
2011 : 16515 : 20,659,000 : 1 in 1250.923
2016 : 15683 : 24,949,000 : 1 in 1590.831
* Total women 15-49 is taken from the UN's World Population Prospects, but you could also use other estimates, such as census estimates.
See other posts on the forum about pooling.
Using gen wgt = v005/1000000 is not applying the weights, just calculating a weight variable to be used later (note that it uses v005, not v001). The weights are applied later when analyzing the data, and should be adjusted to take into account the probabilities of selection as above.
|
|
|
Re: DHS Burundi 1987 [message #20187 is a reply to message #20182] |
Tue, 06 October 2020 21:39 |
id709nvz
Messages: 43 Registered: March 2019
|
Member |
|
|
Dear,
thanks for your insight and helpful comments. After going through the forum Q&A I follow the following weighting. Could you please evaluate it?
*After opening KR file of 2000 survey
gen wgt=v005/1000000
gen weight=(wgt*FEMALE POPULATION)/FEMALE SAMPLE -For KR 2000; FEMALE POPULATION=14619 and FEMALE POPULATION=15367
gen survey=1
*Same procedure for 2005, 2011 and 2016. Except that I used different total number of female population, female sample and with gen survey 2, 3, and 4 respectively. Then I appended the data starting from the latest survey (2016). Afterward, I did the following.
egen cluster=group(survey v021) *V021 is PSU and survey identifies year of survey (coded 1, 2, 3 and 4)
egen stratum=group(survey v022) *v022 is sample strata for sampling error
svyset cluster [pw=wgt], strata(stratum) singleunit(centered)
Is it correct to use: tab x1 x2 [iweight=wgt] or tab x1 x2 [iweight=weight]
how about svy: reg Y x1 x2 (Will this understand the complex nature of the survey).
Added to this: svy is not supported with ivreg2 stata command is there an alternative to this? I simply used ivreg2 with cluster option at v001.
Thank you in advance for any comments.
Kind regards!
|
|
|
Re: DHS Burundi 1987 [message #20193 is a reply to message #20187] |
Wed, 07 October 2020 00:31 |
Trevor-DHS
Messages: 805 Registered: January 2013
|
Senior Member |
|
|
Yes, this mostly looks good. A couple of notes:
1) For 2000, FEMALE POPULATION=14619 and FEMALE SAMPLE=15367. I assume this is just a typo in the message.
2) For the svyset it should use [pw=weight]. wgt is for use with a single survey, weight would be used for the pooled dataset.
3) For tabulating the combined pooled file, you should use tab x1 x2 [iweight=weight], not wgt
4) The svy: reg will use whatever you have defined in the svyset, so that should be weight for the pooled dataset, or wgt if you are using only a single survey.
5) I don't know ivreg2, so I can't advise on this, but typically not taking the complex sampling into account (with svy) means that significance tests and confidence intervals are not accurate.
|
|
|
|
|
|
|
|
|
Re: DHS Burundi 1987 [message #29846 is a reply to message #29845] |
Mon, 12 August 2024 17:33 |
Trevor-DHS
Messages: 805 Registered: January 2013
|
Senior Member |
|
|
Hi Jacob
There are two forms of the HW file: 1) Where the anthropometric data collection was based on children in the household roster, 2) Where the anthropometric data collection was based on children in the mother's birth history. The example just above for Nigeria 2003 is for the first kind, and for Burundi 1987 it is the second kind (actually the oldest kind from the earliest surveys). You can tell the difference by the variable names. If you find hwhhid then this is for the first kind based on the household roster, and if you find hwcaseid this is the second kind based on the mother's birth history.
The code for Burundi 1987 is given at the top of the thread here: [url=https://userforum.dhsprogram.com/index.php?t=msg&th =1642&goto=3219&#msg_3219][/url]
Regards. Trevor
|
|
|