Do while loop SAS

[Nishant_saxena]

I am stuck to this prob;em please help me out:

A bike deliver a milage of 20 miles per gallon. write a code in SAS so that the code stops generating observations when distance reaches 250 miles or when 10 gallons of fuel  have ben used.

[art297]

What have you tried?

Art, CEO, AnalystFinder.com

[Nishant_saxena]

I was trying some stuff like:

data milage;
do gallons= 1 to 10;
while(distance<250);
run;

[Jagadishkatam · Accepted solution]

Consider that you have a dataset with miles and you want to create a new dataset creating a new variable and if this new variable values reaches the 250 mark then you need to stop. Use the do until as i used.

data have;
do miles=100 to 1000 by 50;
output;
end;
run;

data want;
do until(mile<=250);
set have;
mile=miles;
end;
run;

[Nishant_saxena]

This solution is exactly working

Thanks a lot

[MikeZdeb]

Hi, do you really need a loop ...

data want;
set have (where=(miles le 250));
mile=miles;
run;

If you don't want that new variable, don't use "mile=miles"