The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Countries » Kenya » Issues with Education Data in DHS Dataset for Kenya (2022 and 2014)
Issues with Education Data in DHS Dataset for Kenya (2022 and 2014) [message #29862] Wed, 14 August 2024 09:45 Go to next message
n.borgmann is currently offline  n.borgmann
Messages: 10
Registered: August 2024
Member
Dear DHS Team,

I am reaching out with a question regarding the DHS dataset for Kenya, specifically about the variables V107 (years of schooling) and V106 (education level) for the years 2022 and 2014.

In the 2022 dataset, there seem to be only a very small number of individuals with more than 8 years of schooling--just 7 individuals. Considering that Kenya's education system typically includes both primary and secondary schooling, which should exceed 8 years, I am puzzled by this finding.

I have seen discussions in the forum suggesting that there were issues with this variable in previous datasets and that the revised dataset will be released by the end of this week. However, the dataset for 2014 was referenced as being accurate. Upon reviewing the 2014 data, I found that the maximum value for years of schooling is also 8 years. This seems inconsistent with the data for variable V106, where many individuals fall into the third category, which is supposed to be higher than secondary education.

Could you please provide an explanation for these results? Is there a specific reason for this discrepancy, or could the data potentially be incorrect? Understanding this would be crucial for my work.

Thank you very much for your time and assistance. I greatly appreciate your help.

Best regards,

Nils

[Updated on: Wed, 14 August 2024 09:45]

Report message to a moderator

Re: Issues with Education Data in DHS Dataset for Kenya (2022 and 2014) [message #29871 is a reply to message #29862] Thu, 15 August 2024 10:07 Go to previous messageGo to next message
Bridgette-DHS is currently offline  Bridgette-DHS
Messages: 3196
Registered: February 2013
Senior Member
Following is a response from Senior DHS staff member, Tom Pullum:

You may be misinterpreting v107. That variable gives the number of years WITHIN the reported level, v106. The total number of years is v133, "education in single years". It is constructed by combining v106 and v107. In the Kenya 2014 survey, the following table has v106 for columns, v107 for rows, and v133 for cell values (ignore the Total row and column).
/index.php?t=getfile&id=2384&private=0

In the Kenya 2022 survey there was an error in the construction of the education variables. New versions of the files for that survey were put on the website just a few days ago and you should use them in place of the old files.

I can't account for illegal values, such as the 7 cases you found (if indeed they are illegal) in the KE 2022 survey. DHS files have remarkably few such values, but there are some. You may be able to find out whether and how they were altered by comparing with the new versions of the data files. (I can't do that because the internal data folder I use has not been updated yet).

Let us know if you have other questions.

  • Attachment: v107-v106.png
    (Size: 17.00KB, Downloaded 105 times)
Re: Issues with Education Data in DHS Dataset for Kenya (2022 and 2014) [message #29873 is a reply to message #29862] Thu, 15 August 2024 10:12 Go to previous messageGo to next message
n.borgmann is currently offline  n.borgmann
Messages: 10
Registered: August 2024
Member
Thank you very much for your detailed explanation. This clarifies everything, and I probably wouldn't have figured it out on my own. I greatly appreciate your help.
Re: Issues with Education Data in DHS Dataset for Kenya (2022 and 2014) [message #29880 is a reply to message #29871] Fri, 16 August 2024 04:06 Go to previous message
n.borgmann is currently offline  n.borgmann
Messages: 10
Registered: August 2024
Member
Thank you very much for the detailed response.

As I mentioned in another post, there was a mix-up on my end regarding the variable names.

Thank you so much for the help, my calculations make sense now!
Previous Topic: Variable for Long/Short questionnaire IR
Next Topic: Update on Kenya DHS 2022 Data and Guidance on Educational Variables for Analysis
Goto Forum:
  


Current Time: Mon Nov 18 07:31:30 Coordinated Universal Time 2024