BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
hanskronie
Calcite | Level 5

 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

1 ACCEPTED SOLUTION

Accepted Solutions
RW9
Diamond | Level 26 RW9
Diamond | Level 26

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

char_value=put(number_value,tod8.);

View solution in original post

2 REPLIES 2
RW9
Diamond | Level 26 RW9
Diamond | Level 26

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
Tourmaline | Level 20

Do like this

 

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

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 2 replies
  • 12601 views
  • 2 likes
  • 3 in conversation