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
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!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.
Select SAS Training centers are offering in-person courses. View upcoming courses for: