convert number with decimal in datetime

[luca87]

Hi,

I have this number 44824.689149 in sas table. If I put this it into an excel and format it in date time I get the following result is 20/09/2022 16:32:22.

How can I do this in sas?

I try with

data test;
a=put(44824.689149,datetime16.);
run;

but I get: 01jan60:12:27:05

Thanks,

Luca

[Tom · Accepted solution]

Excel counts days from a different starting point.  Excel stores time of day as a fraction of a day. You can use the DHMS() function to days (including fractional days) into datetime.

data test;
  datetime=dhms('30DEC1899'd+44824.689149,0,0,0);
  format datetime datetime19.;
run;

317  data test;
318    datetime=dhms('30DEC1899'd+44824.689149,0,0,0);
319    format datetime datetime19.;
320    put datetime=;
321  run;

datetime=20SEP2022:16:32:22

[abaker_ca]

I just posted this exact same problem with my own data set and then found your solution. Thank you!