也想知道

试试：

复制代码

*It's better to trim you string variables first (in this case x4,x5), this will guarantee the following procedure will work in any condition

replace x4=trim(x4)
replace x5=trim(x5)


foreach var of varlist x2-x5 {
bysort id: replace `var'=`var'[_n-1] if missing(`var')
}

by id: keep if _n==_N

pretty cool, thanks~