stata数据处理+回归基础

clear

**删除重复值

import excel "C:\Users\Administrator\Desktop\供应链金融\财务指标年度.xls", sheet("回归指标1.0") firstrow

gen t = year(time)

bys id t:g n=_n

bys id t:g N=_N

keep if n==N

drop n N

xtset id t

gen gro = d.income/l.income

**剔除缺失值

gen m=1 if invcash==0| borcash==0| deltacash==0| finalcash==0

drop if m==1

dropm

**winsorize处理

winsor2 var1 var2,suffix(w),cut(2.5,99)

**合并数据