The DHS Program User Forum: India » Line Number in the BR file

Home » Countries » India » Line Number in the BR file (Line Number is not unique in the BR file )

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

Line Number in the BR file [message #24779]

Sun, 10 July 2022 04:51

hvs0013
Messages: 11
Registered: April 2022

Member

Hi,

I am currently working with the BR file for India. I have a few observations in the data set that have the same line number within a household, that is, the child of mother is not uniquely identified by cluster (hv001), household number (hv002) and the line number of the child in the household. When I look at the case id, I see the respondent of these children are different in the household, that is , it is potentially a response by two different women in the same household. However, the line number of the children by these two women is the same. I wanted to confirm if these observations are a result of an error and need to be dropped. Thank you .

Report message to a moderator

Re: Line Number in the BR file [message #24800 is a reply to message #24779]

Wed, 13 July 2022 09:00

Janet-DHS
Messages: 888
Registered: April 2022

Senior Member

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

The unique identifier for a woman in the IR file is v001 v002 v003, and the unique identifier for a child in the KR or BR files is v001 v002 v003 bidx. bidx is nested within v001 v002 v003. There can be duplicate values of bidx if the household incudes more than one woman with children.

If the child is in the PR file, its line number in the PR file (hvidx) is given in the KR or BR files with b16. You should not find any duplicates of b16 within a household. Please let us know if that is what you are seeing.

Report message to a moderator

Re: Line Number in the BR file [message #24804 is a reply to message #24800]

Thu, 14 July 2022 01:21

hvs0013
Messages: 11
Registered: April 2022

Member

Hi,

Thank you for the clarification. Yes, I am still looking at duplicate observations in the BR file. For India, I opened the BR file. I identified the households using v001(cluster number) and household number (v002). I dropped observations where b16=0 or b16=.
I also dropped births that were not single births. I am left with 41 observations where households have children with the same b16. Please let me know if I need to provide more information.

Thank you.

Report message to a moderator

Previous Topic:	Making complex estimations
Next Topic:	Possible error with V626a (Unmet need)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Fri Nov 22 04:16:53 Coordinated Universal Time 2024