topic Re: how to convert numeric time to character hh:mm:ss format in SAS Programming

how to convert numeric time to character hh:mm:ss format

hanskronie — Thu, 15 Feb 2018 09:46:15 GMT

How do i convert numeric time which is in format best12. and length as 8 for ex- 45240 to character hh:mm:ss format?

Any clue please

RW9 — Thu, 15 Feb 2018 09:48:12 GMT

Follow the basic SAS training. Numerics can be "put" into text variables using given formats, so for instance:

char_value=put(number_value,tod8.);

PeterClemmensen — Thu, 15 Feb 2018 09:52:32 GMT

Do like this

data test;
	format time best12.;
	time=45240;
	char_time=put(time,tod8.);
run;