4# extensive58
set more off
cd c:\data
clear
input str6 Stk str10 Acc str3 Indcd A B C
000001 2004-12-31 I01 0 0 0
000001 2005-12-31 I01 0 0 0
000001 2006-12-31 I01 0 0 0
000001 2007-12-31 I01 0 0 0
000001 2008-12-31 I01 0 0 0
000001 2009-12-31 I01 0 0 0
000002 2004-12-31 J01 0 0 0
000002 2005-12-31 J01 0 0 0
000002 2006-12-31 J01 0 0 0
000002 2007-12-31 J01 0 0 0
000002 2008-12-31 J01 0 0 0
000002 2009-12-31 J01 0 0 0
end
save input.dta, replace
list
clear
input str6 Stk str10 Acc T
000001 2004-12-31 -0.084574
000001 2005-12-31 0.213798
000001 2006-12-31 2.704307
000001 2007-12-31 1.03384
000001 2008-12-31 -0.76828
000001 2009-12-31 7.192903
000002 2004-12-31 0.612774
000002 2005-12-31 0.570613
000002 2006-12-31 0.610436
000002 2007-12-31 1.303504
000002 2008-12-31 -0.127434
000002 2009-12-31 0.385817
000004 2004-12-31 -1.429625
end
save input1.dta, replace
use input, clear
list
use input1, clear
list
use input, clear
merge m:1 Stk Acc using input1
list