我有个面板数据,我想用2000年作为基期,1.保持2000年的hs2结构,用2000年的ratio_new计算其余年份对应的hs2ratio__new?
数据如下:clear
input float year str2 hs2 float ratio_new str8 id float total_income
2000 "06" .03231248 "1102001" 0
2000 "06" .03231248 "1102002" 0
2000 "06" .03231248 "1102003" 0
2000 "06" .03231248 "1102004" 0
2000 "06" .03231248 "1102005" 0
2000 "06" .03231248 "1102006" 0
2000 "06" .03231248 "1102007" 0
2000 "06" .03231248 "1102008" 0
2000 "06" .03231248 "1102009" 0
2000 "06" .03231248 "1102010" 0
2000 "06" .03231248 "1102011" 0
2000 "06" .03231248 "1102012" 0
2000 "06" .03231248 "1102013" 0
2000 "06" .03231248 "1102014" 0
2000 "06" .03231248 "1102015" 0
2000 "06" .03231248 "1102016" 0
2000 "06" .03231248 "1102017" 0
2000 "06" .03231248 "1102018" 0
2000 "06" .03231248 "1102019" 0
2000 "06" .03231248 "1102020" 0
2000 "06" .03231248 "1102021" 0
2000 "06" .03231248 "1102022" 0
2000 "06" .03231248 "1102023" 0
2000 "06" .03231248 "1102024" 0
2000 "06" .03231248 "1102025" 0
2000 "06" .03231248 "1102026" 0
2000 "06" .03231248 "1102027" 0
2000 "06" .03231248 "1102028" 0
2000 "06" .03231248 "1102029" 0
2000 "06" .03231248 "1102030" 0
2000 "06" .03231248 "1102031" 0
2000 "06" .03231248 "1102032" 0
2000 "06" .03231248 "1102033" 0
2000 "06" .03231248 "1102034" 0
2000 "06" .03231248 "1102035" 0
2000 "06" .03231248 "1102036" 0
2000 "06" .03231248 "1102037" 0
2000 "06" .03231248 "1102038" 0
2000 "06" .03231248 "1102039" 0
2000 "06" .03231248 "1102040" 0
2015 "04" .3283082 "1103001" 0
2008 "04" .7546931 "1103001" 0
2011 "04" .454619 "1103001" 0
2013 "06" 1 "1103001" 0
2010 "06" 1 "1103001" 0
2014 "06" 1 "1103001" 0
2011 "06" 1 "1103001" 0
2008 "06" 1 "1103001" 0
2013 "04" .557392 "1103001" 0
2014 "04" .4627948 "1103001" 0
2012 "06" 1 "1103001" 0
2012 "04" .5831468 "1103001" 0
2009 "04" 1 "1103001" 0
2007 "01" 1 "1103001" 0
2010 "04" .26872122 "1103001" 0
2011 "06" 1 "1103002" 0
2014 "06" 1 "1103002" 0
2012 "06" 1 "1103002" 0
2013 "04" .557392 "1103002" 0
2008 "04" .7546931 "1103002" 0
2015 "04" .3283082 "1103002" 0
2010 "04" .26872122 "1103002" 0
2013 "06" 1 "1103002" 0
2008 "06" 1 "1103002" 0
2007 "01" 1 "1103002" 0
2012 "04" .5831468 "1103002" 0
2014 "04" .4627948 "1103002" 0
2011 "04" .454619 "1103002" 0
2010 "06" 1 "1103002" 0
2009 "04" 1 "1103002" 0
2014 "06" 1 "1103003" 0
2013 "06" 1 "1103003" 0
2010 "04" .26872122 "1103003" 0
2010 "06" 1 "1103003" 0
2009 "04" 1 "1103003" 0
2011 "06" 1 "1103003" 0
2008 "04" .7546931 "1103003" 0
2012 "04" .5831468 "1103003" 0
2012 "06" 1 "1103003" 0
2011 "04" .454619 "1103003" 0
2008 "06" 1 "1103003" 0
2007 "01" 1 "1103003" 0
2015 "04" .3283082 "1103003" 0
2014 "04" .4627948 "1103003" 0
2013 "04" .557392 "1103003" 0
2011 "06" 1 "1103004" 0
2014 "06" 1 "1103004" 0
2013 "04" .557392 "1103004" 0
2007 "01" 1 "1103004" 0
2012 "04" .5831468 "1103004" 0
2008 "04" .7546931 "1103004" 0
2010 "06" 1 "1103004" 0
2009 "04" 1 "1103004" 0
2013 "06" 1 "1103004" 0
2010 "04" .26872122 "1103004" 0
2015 "04" .3283082 "1103004" 0
2011 "04" .454619 "1103004" 0
2012 "06" 1 "1103004" 0
2014 "04" .4627948 "1103004" 0
2008 "06" 1 "1103004" 0
end
[/CODE]