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;
... View more
