Here's a slightly different version, how I would do it:
data sample; input ID $1 Amount; datalines; A 0.1 A 0.2 A 0.3 B 0.4 B 0.5 ; run;
proc sql noprint; create table sample as select unique *, sum(amount) as total_amount from sample group by id; quit; run;
... View more
