topic Re: How to skip every third number in DO iterative loop in SAS Programming

How to skip every third number in DO iterative loop

knveraraju91 — Mon, 11 Dec 2023 03:57:18 GMT


data want;
do week=1 to 100;
day=week+1;
llc=day+;
ulc=day+;
end;
run;

Dear,

I need help in DO iterative code. I need to skip every third number and create two variables for each row by adding different numbers.

eg; for 1,2,3 combination I need to skip 3 and create llc and ulc variables for 1,2.

For row 1, i need to calculate llc=day+2 and ulc=day+5.

For row 2, i need to calculate llc=day+3 and ulc=day+6

I need to repeat above for all three set combinations. Please suggest. Thank you

output needed

week day llc ulc

1 2 4 7

2 3 6 9

4 5 7 10

5 6 9 12

Re: How to skip every third number in DO iterative loop

Tom — Mon, 11 Dec 2023 04:41:19 GMT

Did you mean something like this?

data want;
 week=0;
 day=1;
 do until(week>10);
   do inc=1 to 3;
     week+1;
     day+1;
     llc=day+1+inc;
     ulc=day+4+inc;
     if inc<3 then output;
     else week+-1;
   end;
 end;
 drop inc;
run;

Obs    week    day    llc    ulc

  1      1       2      4      7
  2      2       3      6      9
  3      3       5      7     10
  4      4       6      9     12
  5      5       8     10     13
  6      6       9     12     15
  7      7      11     13     16
  8      8      12     15     18
  9      9      14     16     19
 10     10      15     18     21
 11     11      17     19     22
 12     12      18     21     24

Re: How to skip every third number in DO iterative loop

Patrick — Mon, 11 Dec 2023 05:12:00 GMT

Here one option

data want;
  do week=1 to 100;
    rem=mod(week,3);
    if rem = 0 then continue;
    day=week+1;
    llc=day+1+rem;
    ulc=day+4+rem;
    output;
  end;
  drop rem;
run;