data try;
input name $ yesno $ price;
datalines;
chris yes 10
chris no 10
chris yes 30
chris yes 40
chris no 50
chris yes 60
ken yes 60
ken yes 40
ken no 30
ken yes 10
tom no 10
tom no 20
tom no 30
tom yes 70
;
data want;
do until(last.name);
set try;
by name;
length yes no sumofyes sumofno 8 ;
if yesno='yes' then do;yes+1;sumofyes+price;end;
if yesno='no' then do;no+1;sumofno+price;end;
end;
output;
call missing(yes ,no, sumofyes, sumofno );
keep name yes no sumofyes sumofno ;
run;
... View more