How to add a minute to HH:MM

[sra2786]

I want to create a table that has all the HH:MM possible for the day (ie, 00:00, 00:01, 00:02, .... 23:58, 23:59).  I do not know how to do this.  I have searched for a solution but I cannot find one.

DATA TIMES;

HHMM = '00:00't;

DO i=0 to 1439

   HHMM = HHMM + 1 minute    < I don't know how to do this

   output;

END;

Can someone tell me how to do this/

Thanks.

Sandy

[Reeza · Accepted solution]

Time is in seconds, so a minute is 60 seconds. Try adding 60 instead of 1.

You could also do it as:

Try a loop like this (untested)

do time="00:00"t to "23:59"t by 60;
output;
end

[sra2786]

Thanks.  That worked.