Hi all,

I need help in reshaping long (year2007-year2012). The desired outcome would be something like: AF-DE-2007-1 etc. where AF and DE are ISO codes for country1 and country2, 2007 is the year and 1 indicates yes.

The attached is my data.

This is the code I used but it says the variable id does not uniquely identify the observations:

reshape long year, i(ISO2C_COUNTRY1) j(Year)


Thank you!