Dear Statalist,

I am working on a dataset as below:
Code:
* Example generated by -dataex-. To install: ssc install dataex
clear
input byte id_country str9 indicator_name byte indicator_code int(year1 year2) byte year3 int year4
1 "Name of 1" 1 342  43  3   .
1 "Name of 2" 2  23 526  4  42
1 "Name of 3" 3   2   3 32 235
2 "Name of 1" 1   4  52  5   .
2 "Name of 2" 2   5 865  7   .
2 "Name of 3" 3  34   3  3 532
3 "Name of 1" 1   3   2 54   5
3 "Name of 2" 2 674  32  3  24
3 "Name of 3" 3  52 342  2   3
end
So far I have removed indicator_name in order to reshape from long to wide:
Code:
drop indicator_name
reshape wide year*, i(id_country) j(indicator_code)
I would like to use the value in indicator_name as label variable in the new variables. For example, new variable year11 should have a label as "Name of 1 in year 1".
I would appreciate any help.

Thank you!