The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Topics » Reproductive Health » Kenya 2022 calendar data
Kenya 2022 calendar data [message #27774] Mon, 02 October 2023 09:01 Go to previous message
md2022 is currently offline  md2022
Messages: 7
Registered: October 2023
Member
I am working with Kenya 2022 DHS calendar data and running into some issues. I am wondering if anyone else has encountered this and figured out a way to remedy it. I am trying to trim and reverse vcal_1 and vcal_2. This works perfectly for vcal_1, however, when I do it for vcal_2 the string is always much shorter and the reasons for discontinuation are not aligned with vcal_1. I realized that it seems vcal_2 does not have the same number of white spaces, specifically that the length of the string does not seem to match what is mentioned in v019. Has anyone had to add white spaces to their variables to make them aligned? If so, how do you determine the additional number of white spaces needed.

Photos attached to hopefully provide more clarity. Vcal_1[471] and vcal_2[471] as well as Vcal_1[156] and vcal_2[156] show the original data that hasn't been cleaned and the length of vcal_2 is clearly much shorter than vcal_1. The other screenshot is showing the same issue with the Kenya data (I also tested this out and saw the same with Rwanda 2020 data).
 
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: Merging
Next Topic: Event file
Goto Forum:
  


Current Time: Sun Nov 24 18:11:42 Coordinated Universal Time 2024