Generate all hh:mm between 8:00 to 16:00

[hhchenfx]

Hi,

I want to generate a column containing time from 8:00 to 16:00 step by 1 minute.

So the data should look like:

8:00

8:01

8:02

...

15:59

16:00

Can you please help?

Thanks,

HHC

[Tom]

Time is enumerated in seconds. There are 60 seconds in a minute.

do time='08:00't to '16:00't by 60 ;
 ...
end;

[hhchenfx]

Thanks Tom.

How can I put put those in a table in a data step?

Of course, this one below is not working for me. Only 1 row is saved.

Thanks,

HHC

data want; 
format mytime time9.;
do time='08:00't to '16:00't by 60 ;
mytime=time;
end;
run;

[Tom · Accepted solution]

If you want to output multiple observations you need to execute multiple OUTPUT statements.

Can you do it now?

Spoiler

data want; 
format mytime time5.;
do time='08:00't to '16:00't by 60 ;
  mytime=time;
  output;
end;
run;

[hhchenfx]

Thank you, Tom.

HHC