I have a variable called post_time which is in the numeric format with values like 129, 203,252 etc I want to convert this variable into a time variable with values in format like follows:
129 to 13:29
203 to 14:03 etc.
need help for the code on this.
Hi
You can use the HMS function with the appropriate arguments. See sample below.
How can you know that the 1 in 129 is hour 13?
Thanks Bruno
I have a reference dataset (a csv file) and in that reference dataset they have used the post_time variable to calculate the time_variable that i am trying to calculate.
Regards
Amol Gothe
Still the question is, how are AM times represented? Seems like the one who created the file did not really engage her/his brain before starting to type. Or you missed some necessary information (maybe AM/PM is stored in another column of the csv?)
I am afraid it is too vague. Why does 129 = 13:29 and not 01:29 which would seem more logical, how would 01:29 be represented? Could it not also be 129 minutes past a certain time value? Then its just time_point + 129.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.