BookmarkSubscribeRSS Feed
☑ This topic is solved. Need further help from the community? Please sign in and ask a new question.
hhchenfx
Rhodochrosite | Level 12

Hi Everyone,

I would like to get date and time from Epoch value such as:

1688750835759

will give date: 07JUL2023  and GMT time: 17:27:15.759

Can you please help?

Thank you so much.

HHC

 

data test;format epoch comma32.;
input epoch;
datalines;
1688750835759
;
run;

data test;set test;
*format dt datetime24.3;
drop dt seconds;
format date date9.;
format clock_time time9.;

seconds=epoch/1000;
dt = seconds + '01JAN1970:00:00'dt ;
date=datepart(dt);
clock_time=timepart(dt);
run;
1 ACCEPTED SOLUTION

Accepted Solutions
Tom
Super User Tom
Super User

Just convert the milliseconds to seconds and add the number seconds between 1960 and 1970.

251  data test;
252   epoch=1688750835759 ;
253   seconds=epoch/1000;
254   dt = seconds + '01JAN1970:00:00'dt ;
255   put epoch= comma32. / seconds=comma32.3 / dt=datetime24.3 ;
256  run;

epoch=1,688,750,835,759
seconds=1,688,750,835.759
dt=07JUL2023:17:27:15.759

View solution in original post

3 REPLIES 3
Tom
Super User Tom
Super User

Just convert the milliseconds to seconds and add the number seconds between 1960 and 1970.

251  data test;
252   epoch=1688750835759 ;
253   seconds=epoch/1000;
254   dt = seconds + '01JAN1970:00:00'dt ;
255   put epoch= comma32. / seconds=comma32.3 / dt=datetime24.3 ;
256  run;

epoch=1,688,750,835,759
seconds=1,688,750,835.759
dt=07JUL2023:17:27:15.759
hhchenfx
Rhodochrosite | Level 12

Thank you so much, Tom.

HHC

sas-innovate-wordmark-2025-midnight.png

Register Today!

Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.


Register now!

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
  • 3 replies
  • 802 views
  • 1 like
  • 3 in conversation