topic Re: Do Loop to Make a Row for Each Date between a Start and End Date in SAS Programming

Do Loop to Make a Row for Each Date between a Start and End Date

klindsey — Fri, 18 Aug 2023 18:41:35 GMT

Hello,

I have been trying to modify my code so that I can get a row with all of the same information on each date between two dates. I have tried to research this myself, but I keep getting the error:

ERROR: Invalid DO loop control information, either the INITIAL or TO expression is missing or the BY expression is missing, zero,

or invalid.

My code currently is:

data have;

set want;

do offset=0 to intck('day', firstday, finalday);

date= intnx('day',firstday,offset);

output;

end;

format date date9.;

drop firstday finalday;

run;

Thank you for your help!

Re: Do Loop to Make a Row for Each Date between a Start and End Date

Reeza — Fri, 18 Aug 2023 19:09:09 GMT

data have;
set want;
do date=firstday to finalday;
output;
end;
format date date9.;
drop firstday finalday;
run;

Re: Do Loop to Make a Row for Each Date between a Start and End Date

Tom — Fri, 18 Aug 2023 19:22:30 GMT

The error is saying that one of your two variables is missing. So you need to fix that.

There is no need to use INTNX() and INTCK() when the interval you are moving by is the unit that the values are already stored in. DATE values are stored in DAYS. DATETIME and TIME values are stored in SECONDS.

data have;
   set want;
   if missing(firstday) or missing(finalday) then put 'ERROR: missing dates' firstday= finalday= ;
   else do date= firstday to finalday;
     output;
   end;
   format date date9.;
   drop firstday finalday;
run;

Re: Do Loop to Make a Row for Each Date between a Start and End Date

klindsey — Fri, 18 Aug 2023 20:18:11 GMT

This was the first code I used, and I still get the same error.

Re: Do Loop to Make a Row for Each Date between a Start and End Date

klindsey — Fri, 18 Aug 2023 20:20:09 GMT

Ah! It looks like this was it! It just wasn't working since I had missing values. Thank you!