成本粘性statado文档.docxVIP

实用文档 成本粘性statado文档 成本粘性 clear cd C:\Users\Desktop\成本粘性 insheet using FS_Comins.csv,clear destring accper,replace g year=substr(accper,1,4) g month=substr(accper,6,2) drop if typrep==B drop typrep accper ren stkcd code rename b001101000 oprev rename b001201000 cost replace b001209000=0 if b001209000==. replace b001210000=0 if b001210000==. replace b001211000=0 if b001211000==. gen opcost=cost+b001209000+b001210000+b001211000 keep code year code month oprev opcost drop if month==01 g ym=year+month order code year ym sort code year ym destring year month ym,replace bys code year:gen rank=_n bys