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