The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Countries » India » Education Variables in DHS2
Re: Education Variables in DHS2 [message #2193 is a reply to message #2176] Wed, 21 May 2014 11:25 Go to previous messageGo to previous 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.

Report message to a moderator

[Message index]
 
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: Location info
Next Topic: NFHS 4
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ] [ PDF ]

Current Time: Wed Nov 27 11:32:41 Coordinated Universal Time 2024
.:: Contact :: Home :: Privacy Policy ::.

Powered by: FUDforum 3.0.9.
Copyright ©2001-2018 FUDforum Bulletin Board Software

The information provided on this Web site is not official U.S. Government information and
does not represent the views or positions of the U.S. Agency for International Development or the U.S. Government...