topic Re: Converting 11 digit to date value in SAS in SAS Enterprise Guide

Converting 11 digit to date value in SAS

y1232 — Tue, 06 Jun 2023 18:38:24 GMT

Hi,

Looking to see how to convert a 11 digit number to a date value?

Example:

1685937600

I tried this code -

data test;

xdate = put(1685937600, datetime20.);
run;

However my output is 04JUN2013:04:00:00

When it should be June 5th 2023

Re: Converting 11 digit to date value in SAS

PaigeMiller — Tue, 06 Jun 2023 18:53:27 GMT

I don't see how this value of 1685937600 can be June 5, 2023. You need to explain how you got June 5, 2023 as the correct answer.

Re: Converting 11 digit to date value in SAS

ballardw — Tue, 06 Jun 2023 18:56:22 GMT

Why do you think that value should be 5 Jun 2023? Where did that 11 digit value come from?

If a datetime value is supposed to be 5 Jun 2023 it would start at 2001542400.

If a value is a datetime, i.e. with seconds involved, you could request the SAS date value using the DATEPART function, and assign a date format for readability. That value with the Datepart function will return 4 Jun 2013 though.

Re: Converting 11 digit to date value in SAS

Reeza — Tue, 06 Jun 2023 19:05:17 GMT

Your date is using a starting base of 01Jan1970, but SAS uses 01Jan1960.

Not sure if there's an easier fix than this.

options c
data test;
x=1685937600;
xdate = put(1685937600, datetime20.);
xdate2 = x + dhms('01Jan1970'd,0,0,0)-dhms('01Jan1960'd,0,0,0);
format xdate2 datetime20.;
run;

proc print;run;

Re: Converting 11 digit to date value in SAS

y1232 — Tue, 06 Jun 2023 20:05:14 GMT

Yes this actually worked - it does show a time of 4:00 am however it works for me!

Re: Converting 11 digit to date value in SAS

Tom — Tue, 06 Jun 2023 22:18:57 GMT

The extra 4 hours is probably because the date is using GMT and your system is in some other time zone.

Re: Converting 11 digit to date value in SAS

Tom — Tue, 06 Jun 2023 22:21:37 GMT

There is no need to make the function call just use a datetime literal instead of date literal.

xdate2 = x + '01Jan1970:00:00:00'dt;

Also there is no need to subtract the zero from the result.