The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Countries » Other countries » Merging and clustering
Merging and clustering [message #15751] Mon, 10 September 2018 13:45 Go to next message
gosoul is currently offline  gosoul
Messages: 1
Registered: August 2018
Location: paris
Dear Members,
Iam working on DHS AFGHANISTAN 2015 file and have merged Household record file (AFHR) with individual recode (IR) file, my variable of interest in HR file are hv129 and the years of school completed , the coding of the variable in HR file is with _ i.e hv129_01 hv129_02 hv129_03 for each member in the household, i am interested in to keep hohusehold members of age up to 20, do i need to cluster it or i can use PR file instead. any help or do file would be highly appreciated. And I have read "recode manual" and "guide to DHS statistics" but i am not able to grasp the following variables, hv106 means highest educational level attained, that is the highest level of education the household member attended that is No education, Primary, Secondary, Higher or don't know. ,(* Any member below the lower age limit for the education question is classified in the no education category). the next variable hv107 is highest years of education completed, highest year of education gives the years of completed at the level given in hv106. it takes the following value

1, 2 , 3, 4, 5, 6 what does these number stands for from 1-6 . kindly find the attached file below.

Thanking you in anticipation.

Best regards
  • Attachment: Capture.PNG
    (Size: 7.78KB, Downloaded 100 times)

[Updated on: Tue, 11 September 2018 05:43]

Report message to a moderator

Re: Merging and clustering [message #15942 is a reply to message #15751] Mon, 08 October 2018 18:11 Go to previous message
Bridgette-DHS is currently offline  Bridgette-DHS
Messages: 1626
Registered: February 2013
Senior Member
Following is a response from Senior DHS Stata Specialist, Tom Pullum:

This will be much easier if you use the PR file rather than the HR file. You can merge the PR file with the IR file by matching hv001, hv002, hvidx in the PR file with v001, v002 and v003, respectively, in the IR file. Good luck!

Previous Topic: Ethnic groupings in Benin
Next Topic: Haiti DHS 2017, probl with hv108 variable?
Goto Forum:

Current Time: Wed Jun 19 12:07:47 Eastern Daylight Time 2019