- data sample;
- input ID$ type income @@;
- cards;
- 1 1 200 1 2 300 1 3 100 2 1 200 2 3 100 2 4 100
- ;
- run;
- data sample1;
- set sample;
- retain new_income;
- by id;
- new_income+income;
- if first.id then new_income=income;
- run;