Home » Countries » India » Education Variables in DHS2
| Education Variables in DHS2 [message #1257] |
Tue, 28 January 2014 03:47  |
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 #2175 is a reply to message #2173] |
Fri, 16 May 2014 17:26  |
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 #2193 is a reply to message #2176] |
Wed, 21 May 2014 11:25 |
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 #13532 is a reply to message #13488] |
Wed, 15 November 2017 06:42 |
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
|
|
|
|
Goto Forum:
Current Time: Wed Nov 27 11:52:15 Coordinated Universal Time 2024
|
The DHS Program User Forum
Members
Search
Help
Register
Login
Home
