The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Countries » Other countries » Strange education variable in Angola MIS 2011 data
Strange education variable in Angola MIS 2011 data [message #3239] Tue, 11 November 2014 11:40 Go to next message
stakamatsu is currently offline  stakamatsu
Messages: 2
Registered: November 2014
Location: USA
Member
I have a question on Angola's MIS 2011 data.

The only available education variable for all household members in the data set is something wrong. I am sure that this question should be asked in the survey since I find this question in the questionnaire and this statistics is shown in the report.

But the highest education level (hc68) in the individual level data(AOPR61FL.DTA) has too many missing values (92.5%), as attached below. The variable label of this variable is "highest educational level (cs for preliminary & final report)".

-Do you know why this variable is like this? From the label, what can I know?
-How can I get the original variable if possible?

I already sent an email as feedback two or three weeks ago, but I have not yet received any response.

Shinya

. ta hc68
final report) | Freq. Percent Cum.
-------------------+-----------------------------------
no education | 1,051 34.60 34.60
primary | 1,651 54.34 88.94
secondary & higher | 323 10.63 99.57
9 | 13 0.43 100.00
-------------------+-----------------------------------
Total | 3,038 100.00


Re: Strange education variable in Angola MIS 2011 data [message #3252 is a reply to message #3239] Wed, 12 November 2014 10:37 Go to previous messageGo to next message
Bridgette-DHS is currently offline  Bridgette-DHS
Messages: 3017
Registered: February 2013
Senior Member
Missing is 0.43% not 92.5% as stated in your post.
Re: Strange education variable in Angola MIS 2011 data [message #3253 is a reply to message #3252] Wed, 12 November 2014 10:43 Go to previous messageGo to next message
stakamatsu is currently offline  stakamatsu
Messages: 2
Registered: November 2014
Location: USA
Member
Dear Bridgette-DHS, thanks for your response.
I updated my table, and it shows missing now. So, 92.5% missing, as you see below.

. use "E:\DHS\DHSdata\Angola MIS 2011\AOPR61FL.DTA"

. ta hc68,m

highest |
educational level |
(cs for |
preliminary & |
final report) | Freq. Percent Cum.
-------------------+-----------------------------------
no education | 1,051 2.59 2.59
primary | 1,651 4.07 6.66
secondary & higher | 323 0.80 7.45
9 | 13 0.03 7.48
. | 37,562 92.52 100.00
-------------------+-----------------------------------
Total | 40,600 100.00


Re: Strange education variable in Angola MIS 2011 data [message #3259 is a reply to message #3253] Thu, 13 November 2014 08:32 Go to previous message
Bridgette-DHS is currently offline  Bridgette-DHS
Messages: 3017
Registered: February 2013
Senior Member
Following is a response from Senior DHS Specialist, Noureddine Abderrahim:

In the person's file, all household members are listed. However, only kids under 5 are included in question HC68. Also, HC68 is not set for kids who do not have their mother in the household. The system missings are the kids whose mothers are not in the household, and members who are 5 years and older.
Previous Topic: Zambia hiv dataset 2001-02
Next Topic: Questions Regarding Standard DHS & Malaria Testing Protocols
Goto Forum:
  


Current Time: Fri Mar 29 06:51:16 Coordinated Universal Time 2024