Dear all,

I have created a panel data from 2 waves (2004-05 and 2011-12) of Indian Human Development Survey (IHDS) and want to generate a unique household ID (HHID) for each observation based on the participant's HHID in 2005 and HHID in 2012, however I am unable to do so.
In both data sets, State ID (STATEID), District Id (DISTID), PSU ID (PSUID), HHID for the concerned year, Household split ID for the concerned year, Person ID for the concerned year, uniquely identify observations.
What command can I use to create an unique household id for both the years?

Data:

Code:
* Example generated by -dataex-. To install: ssc install dataex
clear
input int(STATEID DISTID PSUID HHID2005 HHID HHSPLITID2005 HHSPLITID PERSONID2005 PERSONID) float WAVE
1 2 1 1 10 0 1  1  1 1
1 2 1 1 10 0 1  1  1 2
1 2 1 1 10 0 1  2  2 1
1 2 1 1 10 0 1  2  2 2
1 2 1 1 10 0 1  3  5 1
1 2 1 1 10 0 1  3  5 2
1 2 1 1  . 0 .  4  . 1
1 2 1 1 10 0 1  5  3 1
1 2 1 1 10 0 1  5  3 2
1 2 1 1 10 0 1  6  4 1
1 2 1 1 10 0 1  6  4 2
1 2 1 2 20 0 1  1  1 1
1 2 1 2 20 0 1  1  1 2
1 2 1 2  . 0 .  2  . 1
1 2 1 2 20 0 1  3  2 1
1 2 1 2 20 0 1  3  2 2
1 2 1 2 20 0 1  4  3 1
1 2 1 2 20 0 1  4  3 2
1 2 1 2 20 0 1  5  4 1
1 2 1 2 20 0 1  5  4 2
1 2 1 2 20 0 1  6  5 1
1 2 1 2 20 0 1  6  5 2
1 2 1 2 20 0 1  7  6 1
1 2 1 2 20 0 1  7  6 2
1 2 1 2 20 0 1  8  7 1
1 2 1 2 20 0 1  8  7 2
1 2 1 2 20 0 1  9  8 1
1 2 1 2 20 0 1  9  8 2
1 2 1 2 20 0 1 10  9 1
1 2 1 2 20 0 1 10  9 2
1 2 1 2 20 0 1 11 10 1
1 2 1 2 20 0 1 11 10 2
1 2 1 2 20 0 1 12 12 1
1 2 1 2 20 0 1 12 12 2
1 2 1 2 20 0 1 13 13 1
1 2 1 2 20 0 1 13 13 2
1 2 1 2 20 0 1 14 14 1
1 2 1 2 20 0 1 14 14 2
1 2 1 2 20 0 1 15 16 1
1 2 1 2 20 0 1 15 16 2
end
label values STATEID stateid
label def stateid 1 "Jammu & Kashmir 01", modify

Here, HHID is the HHID in 2012, HHSPLITID is the HHSPLITID for 2012 and PERSONID is the Person ID in 2012.

Please help.