Kenya 2022 calendar data [message #27774] |
Mon, 02 October 2023 09:01 |
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).
|
|
|