topic Re: convert number with decimal in datetime in SAS Studio

convert number with decimal in datetime

luca87 — Thu, 15 Jun 2023 14:53:46 GMT

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

Re: convert number with decimal in datetime

Tom — Thu, 15 Jun 2023 14:57:34 GMT

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

Re: convert number with decimal in datetime

abaker_ca — Wed, 05 Mar 2025 17:23:13 GMT

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