topic Re: converting numbers to time format in SAS Enterprise Guide

converting numbers to time format

woo — Sat, 03 Mar 2018 05:11:50 GMT

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

Reeza — Sat, 03 Mar 2018 05:33:21 GMT

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);

Kurt_Bremser — Sat, 03 Mar 2018 06:08:28 GMT

This might be a UNIX timestamp, in which case you need to add the difference between 01jan1960 and 01jan1970 to correctly display in SAS.