| Understanding variables in PR & IR files [message #3546] |
Mon, 05 January 2015 06:31  |
Mercysh
Messages: 35
Registered: April 2014
|
Member |
|
|
I am doing data quality checks before analysis and checking consistency between hv112, child reported mother's line number (hv112) and b16 children's line number and hc60 (line number of mother from women's questioonaire).
I merged the Lesotho PR & IR files for 2009 using the following code:
use LSIR60FL
sort v001 v002 v003
save LIR_merge.dta
use LSPR60FL.DTA
gen v001 = hv001
gen v002 = hv002
gen v003 = hv112
save LPR_merge.dta
merge m:1 v001 v002 v003 using LIR_merge.dta
*drop if IR & PR matched
drop if _merge==3
tab b16_* if b16_* !=0
*only for complete women questioonaire
tab hv112 hc60 if hc60 !=994
Please help me understand how the codes 993 & 995 are derived when hv112 is valid line number (1 to 14).
I also don't know if I am interpreting correctly that there are women who reported individuals as their children but the children did not report them as their mothers.
Lastly:
using Lesotho PR file for 2009
I weight the data:
generate weight= hv005/1000000
tab hv105 [iweight= weight]
I get total of 43 162, which is 10 000 more than the 33 719 total reported in the report.
Please help
Mercy
[Updated on: Tue, 06 January 2015 06:51] Report message to a moderator |
|
|
|
The DHS Program User Forum
Members
Search
Help
Register
Login
Home
