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

[klindsey]

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!

[Reeza]

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

[klindsey]

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

[Tom · Accepted solution]

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;

[klindsey]

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