The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Topics » Child Health » child immunization
Re: child immunization [message #24597 is a reply to message #24596] Mon, 06 June 2022 12:29 Go to previous messageGo to previous message
Shireen-DHS is currently offline  Shireen-DHS
Messages: 140
Registered: August 2020
Location: USA
Senior Member
Hello,

Yes you cannot destring the caseid because it contains spaces (i.e. characters).

The case ID is made up of v001 , v002, and v003. See the attached file which is a screenshot of your data before dropping any children and after sorting as follows:

sort v001 v002 v003
br caseid v001 v002 v003 b16 b5

As you can see in the highlighted rows, these are three children with the same mother (v003=2) and in the same household (v002=73). b16 is the child's line number which is missing for one child because they are not living.

So a unique ID for the child should include v001, v002, and b16.

You can learn more about this in the Guide to DHS Statistics, Analyzing Data section, Matching and Merging Datasets subsection: https://www.dhsprogram.com/Data/Guide-to-DHS-Statistics/inde x.htm#t=Analyzing_DHS_Data.htm%23Matching_and_Mergingbc-7&am p;rhtocid=_4_4_6

Hope this helps.

Best,
Shireen Assaf
The DHS Program
 
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: questionnaire and dataset
Next Topic: Child vaccination
Goto Forum:
  


Current Time: Mon Dec 9 05:10:28 Coordinated Universal Time 2024