.
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?
Can you please show us the desired output?
Can you explain your algorithm to compute cost?
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 |
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.