data a;
input Name $ Stockcode Quantity Price;
cards;
a 1 100 5
a 2 200 6
a 2 100 6
b 3 300 7
b 3 100 7
c 1 500 5
;
run;
data b; set a;
id=cats(name,Stockcode);
run;
proc sql;
create table test as
select Name,Stockcode, Price, id,
sum(Quantity) as cum_Quantity
from b
group by id;
quit;
proc sort data=test nodupkeys out=c;by id;run;
data result;set c;Quantity=cum_Quantity; drop id cum_Quantity; run;