The DHS Program User Forum: Merging data files » Merging variables from original DHS with IPUMS DHS

Home » Data » Merging data files » Merging variables from original DHS with IPUMS DHS

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

Re: Merging variables from original DHS with IPUMS DHS [message #18991 is a reply to message #18989]

Tue, 31 March 2020 11:20

Maemae93
Messages: 2
Registered: March 2020

Member

I realise I have made a mistake and created the unique identifier IDHSPID. However, after trying to merge using the following code on Stata:

gen sample = string(81805)

gen str idhspid = sample + caseid

In master file:

merge 1:1 idhspid using "original DHS data"

I get the following, where the observations are not matched

Result # of obs.
-----------------------------------------
not matched 126,364
from master 106,890 (_merge==1)
from using 19,474 (_merge==2)

matched 0 (_merge==3)

Report message to a moderator

[Message index]

		Merging variables from original DHS with IPUMS DHS By: Maemae93 on Tue, 31 March 2020 09:32
		Re: Merging variables from original DHS with IPUMS DHS By: Maemae93 on Tue, 31 March 2020 11:20
		Re: Merging variables from original DHS with IPUMS DHS By: boyle014 on Thu, 10 June 2021 18:49

Previous Topic:	Are the merging commands and results correct
Next Topic:	Mismatch of number of clusters

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Sun Jan 5 04:22:19 Coordinated Universal Time 2025