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;
It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.
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.
Ready to level-up your skills? Choose your own adventure.