黃河泉 发表于 2018-7-2 15:44 
这是合并后的吧,没有帮助?你应该把合并前两个档 show 出"代表性"(会造成问题的)之资料与你的指令!
合并前的(1)
year Volatility_Yr id
2005 .021409 C000002
2006 .029271 C000002
2007 .039814 C000002
2008 .041711 C000002
2009 .028293 C000002
2010 .02273 C000002
合并前的(2)
id year sale
2 2005 1.1e+10
2 2006 1.8e+10
2 2007 3.6e+10
2 2008 4.1e+10
2 2009 4.9e+10
2 2010 5.1e+10
合并命令:
merge m:m id year using sale
合并后的:
year Volatility_Yr id sale
2005 .026392 2 10558851684
2005 .021409 2 10558851684
2006 .029271 2 17848210282
2006 .030627 2 17848210282
2007 .039814 2 35526611302
2007 .036502 2 35526611302
2008 .042932 2 40991779215
2008 .041711 2 40991779215
2009 .028293 2 48881013143
2009 .028112 2 48881013143
2010 .02273 2 50713851443
2010 .024256 2 50713851443