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
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;
Time is enumerated in seconds. There are 60 seconds in a minute.
do time='08:00't to '16:00't by 60 ;
...
end;
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;
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;
Thank you, Tom.
HHC
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.