School attendance for 6-17 years [message #14004] |
Fri, 02 February 2018 05:19 |
neelanjana.p@gmail.com
Messages: 1 Registered: January 2018 Location: New Delhi
|
Member |
|
|
Hi all,
I am working on school attendance , just trying to replicate table 2.19 for Bihar
My estimate is not matching with reported 83.8 state level estimate using hv121, i am getting 85.62 . Am I using wrong variable for computation?
This is my code:
svy: tab hv121 if hv105>5 & hv105<18 & hv024==5 & hv103==1
Outcome
member |
attended |
school |
during |
current |
school |
year | percentages
----------+------------
no | 14.37
attended | 85.62
don't kn | .0186
|
Total | 100
Please help.
|
|
|
Re: School attendance for 6-17 years [message #14141 is a reply to message #14004] |
Fri, 23 February 2018 09:06 |
Bridgette-DHS
Messages: 3199 Registered: February 2013
|
Senior Member |
|
|
Following is a response from Senior DHS Stata Specialist, Tom Pullum:
We apologize for the delay in replying to your February 2 question. DHS has a special procedure for this type of table on school attendance. To get the denominator, you need to know who was in the appropriate age range (e.g. 6-17) in the month of eligibility for school attendance (e.g. April of the calendar year in question). There are several potential ways to estimate whether someone should be in that denominator. The DHS approach is to merge the BR, IR, and MR files with the PR file, thereby obtaining a cmc for month of birth for as many cases as possible (using b3, v011, or mv011, respectively). For remaining cases for which you only have hv105 (age at last birthday in the PR file) to work with, you assume that the person is half way through the year of age. I looked at the NFHS-3 (IA52) data (the relevant table is 2.9) and found that it contains a variable sh18c that gives age in months in April of 2005. Unfortunately, that variable is not routinely put into the data files and it is not in the NFHS-4 (IA71) data (the relevant table is 2.19). I have written a Stata program to replicate the construction of sh18c in the NFHS-3. I do not have time to modify it for the NFHS-4 but you should be able to do that modification. You will of course have to change all the paths as well as the filenames. Also, in NFHS-4 there was separate treatment of the two phases of the survey, so you have to adapt to April of two successive school years. The ages 6 and 17 are included as scalars.
|
|
|
|
|
Re: School attendance for 6-17 years [message #14258 is a reply to message #14257] |
Wed, 14 March 2018 09:26 |
mianrashid
Messages: 13 Registered: February 2016 Location: Pau, France
|
Member |
|
|
Thanks for Reply, recently I participated in a conference, Where a presenter presented a paper and they used this information in her study and mentioned,
" The latest Pakistan Demographic and Health Survey (PDHS) 2012-13 provides data on both nutrition status and schooling outcomes of children. With the sample size of 13,400 households, PDHS provides nationally representative estimates.
Logistic regression will be used with dependent variable: type of school currently attending (government/private). The independent variable for the analysis is nutrition status of children: Underweight/ stunted/wasted). The list of control variables is as follows: wealth quintile, parental education, age of the child, gender, residence (urban/rural), and region (province).",
So, I was finding whether this information is available or not.
MianRashid
|
|
|
|
Re: School attendance for 6-17 years [message #18157 is a reply to message #14141] |
Tue, 01 October 2019 07:28 |
biswaj41_ssf
Messages: 7 Registered: May 2019
|
Member |
|
|
Modification according to NFHS-4 to replicate table no. 2.19 (India national report)
There are two phases in NFHS-4 and we need to define CMC separately for two phases. Just change to the following codes in the help file provided by Tom Pullum. No need to change other codes.
* Generating different CMC for two phases
gen CMC=.
replace CMC = 4+12*(2014-1900) if shphase == 1
replace CMC = 4+12*(2015-1900) if shphase == 2
tab shphase CMC
gen must_use_hv105=0
replace must_use_hv105=1 if in_BR==. & in_IR==. & in_MR==.
gen sh18c_test=CMC-cmc_of_birth
Enjoy!
|
|
|