The DHS Program User Forum: Merging data files

Home » Data » Merging data files » Generating ID variable

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

Re: Generating ID variable [message #14882 is a reply to message #14878]

Fri, 11 May 2018 09:06

Bridgette-DHS
Messages: 3230
Registered: February 2013

Senior Member

Following is a response from Senior DHS Stata Specialist, Tom Pullum:

The only complication with this is that you need to insert leading zeroes when the cluster code is less than 100. The following lines will do this within the PR file.

gen str3 strhv001=string(hv001)
replace strhv001="0"+string(hv001) if hv001<100
replace strhv001="00"+string(hv001) if hv001<10
replace strhv001="BD2014"+strhv001

The constructed variable will automatically reset to 9 columns, even though it started with 3.

Report message to a moderator

[Message index]

		Generating ID variable By: sumonrupop on Thu, 10 May 2018 19:49
		Re: Generating ID variable By: Bridgette-DHS on Fri, 11 May 2018 09:06
		Re: Generating ID variable By: sumonrupop on Fri, 11 May 2018 10:00

Previous Topic:	MERGING THREE DHS DATASETS
Next Topic:	Merging IR and KR with PR - no unique identifiers (for particular countries only)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Mon Sep 15 03:22:52 Coordinated Universal Time 2025