data aaa;
input Polnum $ lobcode $ ClmNum $ paid premium;
cards;
a od aa 500 1000
a od ab 600 1000
a od_nd aa 100 400
b ctp . . 500
;
run;
我如何用first和last语句进行分类汇总得出如下结果:
PolNum LobCode Paid premium ClmNo
a od 1100 1000 2
a od_nd 100 400 1
b ctp 0 500 0
其中ClmNo为ClmNum的个数,下面程序我能得出Paid和Premium,但不知道如何同时得到ClmNo,谢谢
data aaa1;
set aaa;
polkey=cats(polnum,lobcode);
run;
data aaa2;
set aaa1;
by polkey;
if first.polkey then paid1=0;
paid1+paid;
if last.polkey;
drop clmnum paid;
rename paid1=paid;
run;