- data test;
- input @1 id:$5. @11 day @15 bottle;
- cards;
- 100A 1 57
- 100A 2 85
- 100A 3 41
- 100A 6 37
- 200A 1 46
- 200A 3 59
- 200A 4 18
- 200A 5 91
- 300A 2 23
- 300A 4 85
- ;
- run;
- proc sort data=test;by id day;run;
- data test;
- set test;
- by id;
- retain sum 0;
- if first.id then sum=0;
- sum+bottle;
- run;
再将day和sum根据你的需要打上标签即可