I have one numeric value (below) as time and description of the value is "in seconds since the epoch".
would I able to convert it into hh:mm:ss? - Thanks.
1510949673
Sounds like that’s a date time. Do you know what the date of 'epoch' is?
Try to apply the datetime format. If it shows a date and time you expect you can use TIMEPART to extract the relevant time portion.
Proc print data =have;
Format variable datetime.;
Time_portion = timepart(variable);
This might be a UNIX timestamp, in which case you need to add the difference between 01jan1960 and 01jan1970 to correctly display in SAS.
Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!
Check out this tutorial series to learn how to build your own steps in SAS Studio.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.