The DHS Program User Forum - RDF feed
https://userforum.dhsprogram.com/index.php
Questions about weighting when using merged data sets
https://userforum.dhsprogram.com/index.phpindex.php?t=rview&goto=79&th=53#msg_79
DHS user2013-02-20T17:07:48-00:00Re: Questions about weighting when using merged data sets
https://userforum.dhsprogram.com/index.phpindex.php?t=rview&goto=80&th=53#msg_80
I will insert some lines that show the correct way to do the merge. I assume you are using Stata. I am using the "old" version of the merge syntax, which I prefer. Merges are always done with cluster number, household number, and line number.
merge hv001 hv002 hv003 using ARtemp.dta
tab _merge
keep if _merge==3
drop _merge
* the correct weight variable will now be hiv05
The general rule about which weight to use is that hiv05 takes precedence over hv005 or v005 or mv005. If your file includes hiv05, that would be the correct weight.
The wealth index, hv270, is already coded with numbers 1 through 5. If you enter "tab hv270" you will see the labels, not the codes. If you enter "tab hv270, nolabel", you will see the codes. For more on the syntax of labels, enter "help label".