Solution

We demonstrated appending in order to create the long form of this data set:

clear
use panel2007
gen year=2007
save panel2007_append
use panel2008
gen year=2008
append using panel2007_append

Now all you need to do is reshape:

reshape wide score, i(id) j(year)

Last Revised: 8/22/2011