Hai guys ,
I have a requirement , where i have to split time into hours , minutes and seconds .
For example : time is 12 : 40 :12 . I need it as 12 hrs, 40 min and 12 seconds. Kindly give me the syntax for this.
Thanks in advance.
Here you go:
data have;
format datetime datetime.;
datetime = today();
run;
data want;
set have;
date = datepart(datetime);
hour = hour(datetime);
min = minute(datetime);
sec = second(datetime);
run;
Hello,
If your data is in character format, you always could use the SCAN function, with ":" as delimiter and select the position that you want
data want;
set have;
format WANT_var $20. hours minutes seconds $2.;
hours=scan(time,1,':');
minutes=scan(time,2,':');
seconds=scan(time,3,':');
WANT_var=hours||" hrs, "||minutes||" min and "||seconds||" seconds;
run;
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
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.