topic Re: How to add a minute to HH:MM in SAS Programming

How to add a minute to HH:MM

sra2786 — Mon, 24 Jun 2019 21:39:49 GMT

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

Re: How to add a minute to HH:MM

Reeza — Mon, 24 Jun 2019 21:45:35 GMT

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

Re: How to add a minute to HH:MM

sra2786 — Mon, 24 Jun 2019 22:15:27 GMT

Thanks. That worked.