- data one;
- input name $ year cost;
- cards;
- l 1998 2
- l 1998 3
- l 1999 4
- m 2000 5
- m 2001 6
- m 2001 7
- n 2002 8
- n 2003 9
- n 2003 10
- n 2004 21
- n 2004 22
- i 2005 23
- i 2006 24
- i 2006 25
- i 2006 26
- i 2006 27
- ;;;
- proc sort data=one out=one;
- by name year;
- data biao1;
- set one;
- by name year;
- if first.year then sum=0;
- sum+cost;
- if last.year then output;
- drop cost;
- run;
- data biao2;
- set one;
- by name year;
- if first.year then sum=0;
- sum+cost;
- run;