The DHS Program User Forum: Merging data files

Home » Data » Merging data files » Generating ID variable

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

Generating ID variable [message #14878]

Thu, 10 May 2018 19:49

sumonrupop
Messages: 23
Registered: August 2015
Location: Rajshahi

Member

Dear All,
I am trying to make a new cluster number based on the cluster number available in the data set for merging with geographical data, but so far without any luck. The new id that I'd like to make should be 8 digits where 2 are string and others are numeric, where 3 digit available in the data set. As for example, i need to replace cluster number 001 with BD2014001.

Any help would be appreciate.

Md. Nuruzzaman Khan

Report message to a moderator

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

Fri, 11 May 2018 09:06

Bridgette-DHS
Messages: 3199
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

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

Fri, 11 May 2018 10:00

sumonrupop
Messages: 23
Registered: August 2015
Location: Rajshahi

Member

many thanks

Md. Nuruzzaman Khan

Report message to a moderator

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: Thu Nov 28 22:41:48 Coordinated Universal Time 2024