The DHS Program User Forum: Other countries

Home » Countries » Other countries » Merging and clustering

Show: Today's Messages :: Show Polls :: Message Navigator

Merging and clustering [message #15751]

Mon, 10 September 2018 13:45

gosoul
Messages: 7
Registered: August 2018
Location: paris

Member

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
Caraman

Attachment: Capture.PNG
(Size: 7.78KB, Downloaded 398 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

Bridgette-DHS
Messages: 3195
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!

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Fri Nov 15 03:05:10 Coordinated Universal Time 2024