描述的不清楚啊 ,下面程序计算每个seller id 在同一天 总共sale了多少
data a;
input date $10. time $8. v id_s $2. id_b $2.;
DATALINES;
2016.12.1 7:10:00 10 A B
2016.12.1 7:10:01 10 B C
2016.12.1 7:10:02 10 C B
2016.12.1 7:10:02 10 M A
2016.12.1 7:10:03 10 A C
2016.12.1 7:10:09 10 C B
;
run;
proc sort data=a out=b;by id_s date time v id_b;run;
data c;
set b;
by id_s date time v id_b;
retain s;
if first.date then s=0-v;
else s=s-v;
if last.date;
keep id_s date s;
run;