Computing Education Indicators using STATA [message #167] |
Wed, 20 March 2013 12:14 ![Go to next message Go to next message](/theme/default/images/down.png) |
ladokofie
Messages: 1 Registered: March 2013 Location: Manchester, UK
|
Member |
|
|
How can I compute the following education indicators from the DHS household member file using STATA?
1. Net School Attendance Rates (i.e. primary or secondary school attendance rates)
2. Out-of-school Rates
3. School completion Rates (i.e. primary or secondary school completion rates)
4. Average Years of Education.
Do-file for above calculations will be helpful and highly appreciated.
============================================================ ==========================================
I have been struggling with how to generate or compute the following education indicators from the DHS household member recode using STATA for further analysis of educational inequality in Ghana:
1. Net School Attendance Rates (i.e. primary or secondary school attendance rates) 2. Out-of-school Rates 3. School completion Rates (i.e. primary or secondary school completion rates) 4. Average Years of Education.
I know that the indicators can be computed or generated from HV106 to HV110 and HV121 to HV129 (education variables in DHS household member recode) with the household members age variable (HV105). However, I don't know how to go about it using STATA. I would want to generate these education indicators in STATA to enable me to use them for further analysis in STATA (i.e. using these indicators as dependent variables in regression analysis and Concentration Index Decomposition Analysis of Educational Inequality).
I have put this on MEASURE DHS User Forum but so far no reply.
A Do-file for generating and/or calculating the rates above will be helpful and highly appreciated.
I would be very grateful if you could assist me.
Thank you.
[Updated on: Thu, 04 April 2013 14:19] by Moderator Report message to a moderator
|
|
|
Re: Computing Education Indicators using STATA [message #258 is a reply to message #167] |
Thu, 04 April 2013 14:18 ![Go to previous message Go to previous message](/theme/default/images/up.png) ![Go to next message Go to next message](/theme/default/images/down.png) |
Bridgette-DHS
Messages: 3149 Registered: February 2013
|
Senior Member |
|
|
I am attaching a Stata syntax file that will run the tabulations you are interested in. Please note, that education is not my primary area of research. Therefore, there may be some standards in the definitions of attendance, out-of-school, and completion rates that I am unfamiliar with. For example, these rates may be restricted to a certain age range that relates to the age/number of years in the primary or secondary schooling system. I have included examples of how to restrict the age where I thought it may be relevant, but you may need to change the age cut points, as the ones in my examples are only my best guess.
I also include code to weight the data when producing the tabulations as a matter of practice. This will have minimal effect if you are simply interested in the overall rate (the unweighted and weighted proportions are nearly identical), but becomes more important if you want to examine the rates by region, urban/rural area, or other factor.
Finally, I have written this syntax assuming you are using the 2008 Ghana DHS. If you are using a different year, you may want to verify that the variable names have remained the same.
Bridgette-DHS
-
Attachment: Ghana_edu.do
(Size: 2.48KB, Downloaded 1947 times)
|
|
|
|
|
|
Re: Computing Education Indicators using STATA [message #1248 is a reply to message #742] |
Mon, 27 January 2014 14:26 ![Go to previous message Go to previous message](/theme/default/images/up.png) ![Go to next message Go to next message](/theme/default/images/down.png) |
Liz-DHS
Messages: 1516 Registered: February 2013
|
Senior Member |
|
|
Dear User,
In CSPro the table definitions for Table 2.9 School attendance by state on page 33 of the final report are as follows:
crosstab float(1) t205a total+hhage6+hhage7+north+central+east+noreast+west+south
hhsex*(hv025w1+total)+hv025w1+total
exclude(rowzero,colzero,percents,totals,specval)
title( "Table 2.9 School attendance by state"," ",
"Percentage of de facto household population age 6-17 years attending",
" school in the 2005-06 school year by sex, residence, age, and state,",
" India, 2005-06" )
stub( "State" );
Row variables"
Total Total
hhage6 Age
1 6-10 years
2 11-14 years
3 15-17 years
hhage7 Age
1 6-14 years
2 6-17 years
North
Delhi 1
Haryana 2
Himachal Pradesh 3
Jammu & Kashmir 4
Punjab 5
Rajasthan 6
Uttaranchal 7
Central
Chhattisgarh 1
Madhya Pradesh 2
Uttar Pradesh 3
East
Bihar 1
Jharkhand 2
Orissa 3
West Bengal 4
Noreast
Arunachal Pradesh 1
Assam 2
Manipur 3
Meghalaya 4
Mizoram 5
Nagaland 6
Sikkim 7
Tripura 8
West
Goa 1
Gujarat 2
Maharashtra 3
South
Andhra Pradesh 1
Karnataka 2
Kerala 3
Tamil Nadu 4
Column variable:
hhsex
1 male
2 female
Layer variable:
(hv025w1+total)
1 urban
2 rural
hv025w1
1 urban
2 rural
Total
t205aw is a working table
crosstab float(1) t205aw total+hhage6+hhage7+north+central+east+noreast+west+south
hhsex*(hv025w1+total)+hv025w1+total
exclude(rowzero,colzero,percents,totals,specval)
|
|
|
|
|