The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Countries » India » Education Variables in DHS2
Education Variables in DHS2 [message #1257] Tue, 28 January 2014 03:47 Go to next message
Guilhem is currently offline  Guilhem
Messages: 13
Registered: January 2014
Member
Dear all,

the databases in DHS2 (household component and women component) propose various measures of educationnal attainment.
For exemple, in the women database:
highest educational level (v106), highest year of education (v107), education in single years (v133), partner's education level (v701), highest year of education of partner (v702), husband years of education (v715).

However, the education question simply ask the highest grade attained.
Hence, I am wondering how all those variables are constructed and what they actually mean (in particular, highest year of education vs education in single years, which are very different).

Thank you very much for your help.

Best,

Guilhem
Re: Education Variables in DHS2 [message #1387 is a reply to message #1257] Thu, 20 February 2014 14:07 Go to previous messageGo to next message
Liz-DHS
Messages: 1516
Registered: February 2013
Senior Member
Dear User,
I apologize for letting this message get by us. We are currently researching an appropriate response for you.
Thank you!
Re: Education Variables in DHS2 [message #1393 is a reply to message #1387] Thu, 20 February 2014 18:53 Go to previous messageGo to next message
Bridgette-DHS is currently offline  Bridgette-DHS
Messages: 3017
Registered: February 2013
Senior Member
Here is a response from one of our Senior Data Processing Specialists, Lady Ortiz, that should answer your questions.

Highest years of education is the number of years of education within each level of education. V107 should be used together with level of education (V106) in order to know the level to which any particular year belongs.

V133 "Education in single years" refers to the total number of years of education that a person has accomplished. For example if V106 = Secondary and V107 = 01 years, then V133 = 09 (assuming that "primary" is based on 8 years).


Re: Education Variables in DHS2 [message #1394 is a reply to message #1393] Fri, 21 February 2014 06:03 Go to previous messageGo to next message
Guilhem is currently offline  Guilhem
Messages: 13
Registered: January 2014
Member
Thanks for your answer.
What I don't understand however, is that unless I am missing something, the only education question which is asked relates to the "highest grade completed": if that is the case, where is the information from v107 coming from ?

Many thanks
Re: Education Variables in DHS2 [message #2173 is a reply to message #1394] Fri, 16 May 2014 16:40 Go to previous messageGo to next message
Guilhem is currently offline  Guilhem
Messages: 13
Registered: January 2014
Member
Hello,

my last question seems to have been overlooked:
"What I don't understand however, is that unless I am missing something, the only education question which is asked relates to the "highest grade completed": if that is the case, where is the information from v107 coming from ?"

Would you have some information on that matter ?

Many thanks
Re: Education Variables in DHS2 [message #2174 is a reply to message #1394] Fri, 16 May 2014 16:40 Go to previous messageGo to next message
Guilhem is currently offline  Guilhem
Messages: 13
Registered: January 2014
Member
Hello,

my last question seems to have been overlooked:
"What I don't understand however, is that unless I am missing something, the only education question which is asked relates to the "highest grade completed": if that is the case, where is the information from v107 coming from ?"

Would you have some information on that matter ?

Many thanks
Re: Education Variables in DHS2 [message #2175 is a reply to message #2173] Fri, 16 May 2014 17:26 Go to previous messageGo to next message
Liz-DHS
Messages: 1516
Registered: February 2013
Senior Member
Dear User,
According to our standard recode manual:
V106 Highest education level attended. This is a standardized variable providing level of
education in the following categories: No education, Primary, Secondary, and Higher. In
some countries the educational system does not fit naturally within this scheme and a
different categorization was used for the Final Report. In this case, this variable is
constructed as accurately as possible from the country's own scheme and the variable used
for the Final Report is included as a country-specific variable.
V107 Highest year of education gives the years of education completed at the level given in V106.
BASE: All respondents except those answering "No education" or with missing data for
V106 (V106 <> 0 & V106 <> 9).
Hope this helps to answer your question.
Our Standard Recode Manual is on our WEBSITE and can be accessed by clickin on the link http://dhsprogram.com/pubs/pdf/DHSG4/Recode6_DHS_22March2013 _DHSG4.pdf
If this does not answer your question, please feel free to post again.
Thank you!
Re: Education Variables in DHS2 [message #2176 is a reply to message #2175] Sun, 18 May 2014 01:20 Go to previous messageGo to next message
Guilhem is currently offline  Guilhem
Messages: 13
Registered: January 2014
Member
Dear Liz,

thanks for your quick answer.

As there is no question about the actual number of years of schooling in the questionnaire, what puzzles me is that for a given level of hv106 (in the household questionnaire), there are several levels of hv108, even within Indian state.
Giben the question related to hv107 (number of years in the level of education mentionned in hv106), I am wondering where this information is coming from.

To make it clearer: the DHS2 questionnaire asks only what is the highest grade completed by a person (hv106). From this question, I understand that a number of years of education (hv108) can be completed (say 8 years if primary completion demands 8 years in that country), but what I don't understand is how it is possible to have hv107 (a number of years above a given level of education).
Or is there a question that I have missed in the questionnaire ?
Thanks for your help.
Re: Education Variables in DHS2 [message #2193 is a reply to message #2176] Wed, 21 May 2014 11:25 Go to previous messageGo to next message
Liz-DHS
Messages: 1516
Registered: February 2013
Senior Member
Dear User,
After looking at the final report, I came across a footnote, page 28:
"In this report, 'primary school complete' means 5-7 completed years of education, 'middle school complete' means 8-9 completed
years of education, 'high school complete' means 10-11 completed years of education, and 'higher secondary complete and above'
means 12 or more completed years of education."

From the Standard Recode Manual III:http://dhsprogram.com/pubs/pdf/DHSG4/Recode3DHS.pdf
HV105 Age of the household member.
HV106 Highest level of education the household member attended. This is a standardized variable
providing level of education in the following categories: No education, Primary, Secondary,
Higher. Any member below the lower age limit for the education questions is classified in
the "No education" category. Note that the lower age limit may be different from 6 years
in some countries. Country-specific categorizations of education are recorded in RECH3.
HV107 Highest year of education gives the years of education completed at the level given in
HV106.
BASE: All household members except those answering "No education" or with missing
data or the response "Don't know" for HV106 (HV106 <> 0 & HV106 <> 9 & HV106 <>
8).
HV108 Education in single years. This variable is constructed from the educational level (HV106)
and the grade at that level (HV107) as follows:
HV106 = > HV108
0 = > 0
1 = > HV107
2 = > HV107+x
3 = > HV107+y
9 = > 99
x = years to complete primary education
y = years to complete primary and secondary education
where both x and y are country-specific.
HV109 Educational achievement recodes the education of the household member into the following
categories: None, incomplete primary, complete primary, incomplete secondary, complete
secondary, higher education. See related variables HV106, HV107, HV108.
HV110 Whether the household member is still in school. All members aged equal to or older than
the upper limit (usually 25 years) for this question or who have not attended school are
coded 0 (Not in school).

From the Recode Application:
QH11 through QH18 are also country specific variables.
Here is some of the code for the section in the recode dealing with education variables. This was probably programmed in ISSA, but you might be able to glean some useful information from it:

PROC RECH1
if HV015 = 1 then
i = 1;
while i <= HV009 do
HVIDX(i) = i;
{ IDXH4(i) = i; } { country specific section }
temprel = QH04( i );
box temprel => recrel;
1-8 => temprel;
9-11 => 10;
12,13 => temprel-1;
=> missing;
endbox ;
HV101( i ) = recrel;
HV102(i) = yesno(QH05(i));
HV103(i) = yesno(QH06(i));
HV104(i) = QH07(i);
if QH08(i) = 98 | QH08(i) = 99 then
HV105(i) = missing;
elseif QH08( i ) > 95 then
HV105( i ) = 95;
else
HV105(i) = QH08(i); { !! Check 97, 98, 99 }
endif ;
edtemp = QH12( i );
ed = QH12( i );
gr = QH14( i );
wr = QH11( i );
box ed : gr : wr => x106;
notappl, 2 : : => 0 ;
1 : 0-5 : => 1 ;
1 : 6-10 : => 2 ; { Excludes higher secondary }
1 : 11-30 : => 3 ;
1 : : 1 => 1 ;
: : => missing ;
endbox ;
box ed : gr : wr => temp6;
: : 2 => 0 ;
: 0-4 : missing => 6 ;
1 : missing : 1 => 1 ;
2 : : => 1 ;
1 : 0-4 : => 1 ;
1 : 5-7 : => 2 ;
1 : 8-9 : => 3 ;
1 : 10-11 : => 4 ;
1 : 12-25 : => 5 ;
: : => 6 ;
endbox ;
box ed : gr : wr => temp4;
: : 2 => 0 ;
: 0-4 : missing => 4 ;
1 : missing : 1 => 1 ;
2 : : => 1 ;
1 : 0-4 : => 1 ;
1 : 5-7 : => 1 ;
1 : 8-9 : => 2 ;
1 : 10-11 : => 3 ;
1 : 12-25 : => 3 ;
: : => 4 ;
endbox ;
if qh08( i ) < 6 then
shed6( i ) = notappl;
shed4( i ) = notappl;
else
shed6( i ) = temp6;
shed4( i ) = temp4;
endif ;
box x106 => x107 ;
0,missing => notappl;
1 => gr ;
2 => gr - 5 ;
3 => gr - 10;
=> notappl;
endbox ;
HV106(i) = x106;
HV107(i) = x107;
box x106 : x107 => x108;
: missing => missing;
missing : => missing;
: 98 => 98;
8 : => 98;
: 97 => 97;
0 : => 0;
1 : => x107;
2 : => x107+xprm;
3 : => x107+xprm+xsec;
endbox;
HV108(i) = x108;
box x106 : x107 => x109;
missing : => missing;
8 : => 8;
0 : => 0;
1 : 5 => 2; { 5 = years of primary school !! }
1 : => 1;
2 : 5 => 4; { 5 = years of secondary school !! }
2 : => 3;
3 : => 5;
endbox;
HV109(i) = x109;
HV110(i) = NAtoZero(yesno(QH15(i)));
HV111(i) = notappl;
HV112(i) = notappl;
HV113(i) = notappl;
HV114(i) = notappl;
if QH09( i ) = 2 | QH09( i ) = 7 then
HV115( i ) = 0;
elseif QH09( i ) = 1 then
HV115( i ) = 1;
elseif QH09( i ) = 3 | QH09( i ) = 4 then
HV115( i ) = 5;
elseif QH09( i ) = 5 then
HV115( i ) = 4;
elseif QH09( i ) = 6 then
HV115( i ) = 3;
else
HV115( i ) = notappl;
endif ;

if QH09( i ) = 2 | QH09( i ) = 7 then
HV116( i ) = 0;
elseif QH09( i ) = 1 then
HV116( i ) = 1;
elseif !special( QH09( i ) ) then
HV116( i ) = 2;
else
HV116( i ) = notappl;
endif ;
HV117(i) = (QH10( i ) <> notappl & QH10(i) <> 0 & QH06( i ) = 1); { !! }
HV118(i) = notappl;
i = i + 1
enddo;
endif;

If you have additional questions, please feel free to post again.
Re: Education Variables in DHS2 [message #13340 is a reply to message #2193] Wed, 25 October 2017 06:38 Go to previous messageGo to next message
Guilhem is currently offline  Guilhem
Messages: 13
Registered: January 2014
Member
Dear Liz,

thanks very much for this very detailed answer, and my deepest apologies for the delay in mine.

What is still puzzling me if the origin of the information to construction the variable hv107.
Indeed, the household questionnaires only asks about the "highest grade completed", which I believe is coded as hv106.
There is no question about the number of years spent within each grade. That is, there is no question that would allow to know anything about hv107.
Would you happen to know how hv107 (and hence hv108 and hv109) are computed ?

Best,
Re: Education Variables in DHS2 [message #13488 is a reply to message #13340] Thu, 09 November 2017 15:39 Go to previous messageGo to next message
Liz-DHS
Messages: 1516
Registered: February 2013
Senior Member
A response from Dr. Shireen Assaf:
Quote:

Dear Guilhem,

Hv107 gives the years of educated completed at the level given in hv106. A crosstab of hv106 and hv107 would should you how many years spent for instance at the primary level, secondary level, etc. Please see page 12 of the DHS recode manual for further explanation of these variables: https://dhsprogram.com/pubs/pdf/DHSG4/Recode6_DHS_22March201 3_DHSG4.pdf

Thank you.

Shireen Assaf



Re: Education Variables in DHS2 [message #13532 is a reply to message #13488] Wed, 15 November 2017 06:42 Go to previous message
Guilhem is currently offline  Guilhem
Messages: 13
Registered: January 2014
Member
Thanks for your answer.
This is indeed what I would have expected.
However, when I tab hv106 against hv107, for each level of hv106, I get different levels of hv107, even within state.
This is very puzzling, since I would expect primary completion to correspond to a given number of years of education, at least within a state.
So I am wondering how it has been possible to impute a variation in the number of years of education (hv107) within education levels (hv106) when there is actually no question asked in the survey about the number of years spent within a given level of schooling.

Many thanks
Previous Topic: Location info
Next Topic: NFHS 4
Goto Forum:
  


Current Time: Thu Mar 28 19:45:58 Coordinated Universal Time 2024