topic Generate all hh:mm between 8:00 to 16:00 in SAS Programming

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

hhchenfx — Thu, 09 Mar 2023 22:34:38 GMT

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 — Thu, 09 Mar 2023 22:40:41 GMT

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 — Thu, 09 Mar 2023 22:57:22 GMT

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 — Thu, 09 Mar 2023 23:09:53 GMT

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

Can you do it now?

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

hhchenfx — Fri, 10 Mar 2023 00:43:16 GMT

Thank you, Tom.

HHC