data work.pets1;
input name $ item $ cost;
cards;
basil carrots 100
basil hay 50
basil carpet 250
zelda bones 10
zelda kibble 50
;
run;
data want;
do until(last.name);
set pets1;
by name;
do _n_=1 to 3 while(cost<300);
cost=cost*(1.1);
end;
total=sum(cost,total);
output;
end;
run;
proc print noobs;run;
name
item
cost
total
basil
carrots
133.10
133.10
basil
hay
66.55
199.65
basil
carpet
302.50
502.15
zelda
bones
13.31
13.31
zelda
kibble
66.55
79.86
... View more