.

[ginagrodin]

.

[PaigeMiller]

I don't see why you say it is ignoring your upper bound.

In the loop, if cost goes over 300, then the loop stops. So when the cost hits 302.50, it stops. Isn't that what you want?

[PaigeMiller]

Can you please show us the desired output?

Can you explain your algorithm to compute cost?

[novinosrin]

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