topic Re: Do while loop SAS in SAS Programming

Do while loop SAS

Nishant_saxena — Sun, 02 Jul 2017 12:19:47 GMT

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.

Re: Do while loop SAS

art297 — Sun, 02 Jul 2017 12:43:52 GMT

What have you tried?

Art, CEO, AnalystFinder.com

Re: Do while loop SAS

Jagadishkatam — Sun, 02 Jul 2017 14:52:48 GMT

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;

Re: Do while loop SAS

Nishant_saxena — Sun, 02 Jul 2017 14:57:54 GMT

This solution is exactly working

Thanks a lot

Re: Do while loop SAS

Nishant_saxena — Sun, 02 Jul 2017 15:00:22 GMT

I was trying some stuff like:

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

Re: Do while loop SAS

MikeZdeb — Sun, 02 Jul 2017 16:24:32 GMT

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"