求评分
- data a;
- input id flag;
- datalines;
- 123 80000
- 123 100000
- 123 200000
- 123 80000
- 123 700000
- 123 80000
- 123 10000
- 123 20000
- ;
- run;
- data b;
- set a;
- by id ;
- retain count;
- if first.id then do;
- count=flag ;
- end;
- else
- do;
- if count lt flag then
- do;
- count=flag ;
- end;
- end;
- drop flag;
- rename count=flag;
- run;