| merging Household members to women file [message #18297] |
Fri, 01 November 2019 14:25  |
Laxmi Sharma
Messages: 3
Registered: November 2019
|
Member |
|
|
Hello,
I want to use the household member file, because I want to get the women's mother's education level from household member file and merge it with women file.After writing following command , my matched observations are 699,686 . But surprisinly,when I browse the merged data, I can't see any observation in vatiable hc61 hc62 and hc62 . I have used following command but failed to get any output in the browse window.
use hvidx hv001 hv002 hv010 hv024 hc61 hc62 hc68 ///
using "C:\Users\Priya Sharma\Desktop\source for data\householdmember_data\IAPR74FL.DTA" , clear
ren hv001 v001
ren hv002 v002
ren hv024 v024
ren hvidx v003
sort v001 v002 v003 v024
merge 1:m v001 v002 v003 v024 using "C:\Users\Priya Sharma\Desktop\new folder for thesis\hh_mmst.dta"
|
|
|
|
| Re: merging Household members to women file [message #18329 is a reply to message #18297] |
Mon, 11 November 2019 09:01  |
Bridgette-DHS
Messages: 3218
Registered: February 2013
|
Senior Member |
|
|
Following is a response from DHS Research & Data Analysis Director, Tom Pullum:
Without knowing what's in the file "hh_mmst.dta" I cannot reproduce this merge. However, the women's (IR) file includes level of education, as v106. You don't need to merge with the household (PR) file to get it. It's also included in the KR and BR files. Please post again if this does not answer your question.
|
|
|
|
The DHS Program User Forum
Members
Search
Help
Register
Login
Home
