topic Re: I have a do until loop and it is ignoring my upper bound I have set on it. in SAS Programming

.

ginagrodin — Tue, 14 Apr 2020 18:37:44 GMT

Re: I have a do until loop and it is ignoring my upper bound I have set on it.

PaigeMiller — Tue, 14 Apr 2020 18:16:32 GMT

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?

.

ginagrodin — Tue, 14 Apr 2020 18:42:18 GMT

Re: I have a do until loop and it is ignoring my upper bound I have set on it.

PaigeMiller — Tue, 14 Apr 2020 18:21:52 GMT

Can you please show us the desired output?

Can you explain your algorithm to compute cost?

.

ginagrodin — Tue, 14 Apr 2020 18:42:43 GMT

Re: I have a do until loop and it is ignoring my upper bound I have set on it.

novinosrin — Tue, 14 Apr 2020 18:33:51 GMT

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