Derivation
variable: repgp [reporting group] (table[s]: ncdk_fieldlog)
variable: cluster [cluster] (table[s]: ncdk_fieldlog)
variable: hhlistno [household number] (table[s]: ncdk_fieldlog)
variable: lhhno [house number] (table[s]: ncdl_fieldlog)
For Karonga, house is reporting group, cluster and household number concatenated together. For Lilongwe it is just one variable, lhhno.
egen house=concat(repgp cluster hhlistno)