例如ID first final 按照ID分组
A 2009
A
A
A
A
A 2011
B 2007
B
B
B 2010
C 2006
C
C 2011
.
.
如何能变成：
ID first final
A 2009 2011
A 2009 2011
A 2009 2011
A 2009 2011
A 2009 2011
A 2009 2011
B 2007 2010
B 2007 2010
B 2007 2010
B 2007 2010
C 2006 2011
C 2006 2011
C 2006 2011
.
.
proc sort data=yourdata;
by id descending first;
data yourdata1;
set yourdata;
by id descending first;
retain first2;
if first ne . then first2=first;
if first.id then first2=first;
run;
扫码加好友，拉您进群
全部版块
我的主页
收藏
