How to append several data sets so that a variable is appended on its labels?

[Titir Bhattacharya]

Hi,

I'm trying to append 5 rounds of a data, having, among others, the variables state and district. For these variables, the values are labelled with state (district) name and the names are fairly consistent across rounds. But the internal values corresponding to the state(district) names are not consistent across rounds. For eg. if state A has value 1 in round 3, it has value 5 in round 5.

I want to append the data sets in such a way that state(district) is appended on the labels, i.e. based on state(district) names, rather than their internal values.

Is there any way to code this such that I can avoid manually fixing the variables in each round?

Please let me know if my description was vague and you would require more details.
Thanks

PS: I have gone through some of the previous posts on this but havent been able to figure out how to implement it in my case. Any help would be appreciated

[Rich Goldstein]

at a guess, you should first -decode- each data file and then append; see

h decode

[Titir Bhattacharya]

at a guess, you should first -decode- each data file and then append; see

h decode

Thanks Rich! this was such a simple solution!