The DHS Program User Forum: Child Health

Home » Topics » Child Health » duplicate caseid

Show: Today's Messages :: Show Polls :: Message Navigator

Re: duplicate caseid [message #24424 is a reply to message #24397]

Fri, 13 May 2022 10:59

Janet-DHS
Messages: 698
Registered: April 2022

Senior Member

Following is response from DHS Research & Data Analysis Director, Tom Pullum:

What survey and what file are you using? In the KR file, for example, there is a record for every child born in the past five years. caseid is the mother's ID code. Because many women had more than one child in the past five years, there will be several records with the same value of caseid, but children of the same mother will have different values of bidx (1, 2, etc.). In the IR file, there should never be a repeat of the same caseid, although very rarely we will find a duplicate. To check for duplicates in the IR file, in Stata, enter "gen ncases=1", then "collapse (sum) ncases, by(caseid)", then "tab ncases" and "list if ncases>1, table clean".

Report message to a moderator

[Message index]

		duplicate caseid By: adis on Mon, 09 May 2022 02:51
		Re: duplicate caseid By: Janet-DHS on Tue, 10 May 2022 10:13
		Re: duplicate caseid By: adis on Tue, 10 May 2022 13:18
		Re: duplicate caseid By: Janet-DHS on Fri, 13 May 2022 10:59
		Re: duplicate caseid By: adis on Thu, 19 May 2022 09:13
		Re: duplicate caseid By: Janet-DHS on Fri, 20 May 2022 15:45
		Re: duplicate caseid By: adis on Fri, 20 May 2022 16:45

Previous Topic:	How to do logistic regression for infant mortality
Next Topic:	Tuberculosis and Childhood Tuberculosis

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Sat Apr 27 09:26:44 Coordinated Universal Time 2024