1# apple_orange
set more off
set linesize 255
clear
cd c:\data
input tic fyear x1 x2 x3 x4
1 2001 1 0 3 4
1 2002 1 2 2 5
2 2001 1 2 2 5
2 2002 3 4 5 7
3 2001 1 0 3 4
3 2002 2 4 5 1
end
recast int _all
save 1.dta, replace
clear
input tic fyear Y1 Y2 Y3 Y4 Y5 Y6
1 2001 1 0 3 4 6 8
1 2002 1 2 2 5 8 2
2 2001 1 2 2 5 6 7
2 2002 3 4 5 7 3 7
end
recast int _all
save 2.dta, replace
use 1, clear
merge 1:1 tic fyear using 2
list