- data a;
- input number year name $;
- cards;
- 001 2000 XH
- 001 2001 XW
- 001 2002 XH
- 002 2000 XW
- 002 2001 XH
- 002 2002 XW
- ;
- run;
- proc sort data=a;
- by number name;
- run;
- data b;
- set a;
- by number name;
- if first.name then times=1;else times+1;
- run;
-
- proc sort data=b;
- by number year name ;
- run;