The DHS Program User Forum: Other countries » Zambia 2018 -- duplicates in cluster number and household number

Home » Countries » Other countries » Zambia 2018 -- duplicates in cluster number and household number (Trouble merging datasets due to duplicates)

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

Zambia 2018 -- duplicates in cluster number and household number [message #24978]

Fri, 12 August 2022 11:47

nchesterman
Messages: 1
Registered: August 2022

Member

Hi all,

I am attempting to merge variables from the male and female datasets onto the household dataset. The DHS help site for this (https://dhsprogram.com/data/Merging-Datasets.cfm) indicates that v001 and v002 (cluster and household numbers) should be unique for the datasets. However, I am finding that these two variables do not uniquely identify all observations; there are many duplicates of these two variables in the dataset.

I also checked my variables of interest, and found that the data differs between duplicated cases. So the households are not true duplicates.

Has anyone else encountered this issue for the Zambia dataset, and have suggestions for how to successfully merge on cluster and household numbers with the household dataset?

Thanks,
Nathan

Report message to a moderator

[Message index]

		Zambia 2018 -- duplicates in cluster number and household number By: nchesterman on Fri, 12 August 2022 11:47
		Re: Zambia 2018 -- duplicates in cluster number and household number By: Janet-DHS on Thu, 01 September 2022 16:30

Previous Topic:	Analyse multiniveau
Next Topic:	Values in contraceptive calendar - South Africa

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Fri Nov 29 18:48:01 Coordinated Universal Time 2024