topic Re: Referencing a table that has a set of dates in SAS Date format that I want to convert to Date9. in SAS Programming

Referencing a table that has a set of dates in SAS Date format that I want to convert to Date9.

Jyuen204 — Thu, 25 Apr 2024 18:03:41 GMT

I am referencing a table for some data and the table contains a date field but it is set in a SAS Date format:
23480
23481
23482 etc

I want to query the data and pull it with Date9 format

I tried :
SELECT DATEPART(RT_DATE) AS PERIOD_DT format = date9.

but it returns with the base SAS date (Jan 1 1960)

Is there another method to use in my select to get the date to convert? Thanks!

Re: Referencing a table that has a set of dates in SAS Date format that I want to convert to Date9.

PaigeMiller — Thu, 25 Apr 2024 18:20:59 GMT

If the values are integers, like 23480, you just assign the DATE9. format to this variable.

Re: Referencing a table that has a set of dates in SAS Date format that I want to convert to Date9.

Tom — Thu, 25 Apr 2024 18:41:18 GMT

Why did you treat the values as if they were DATETIME values instead of DATE values?

SAS stores datetime values in seconds and date values in days.

The number 23,480 is 01JAN1960:06:31:20 when treated as a count of seconds but it is 14APR2024 when treated as a count of days.

Re: Referencing a table that has a set of dates in SAS Date format that I want to convert to Date9.

Jyuen204 — Thu, 25 Apr 2024 18:45:44 GMT

I was not aware that I did. I am simply looking for a select option to get a date9. date from a source table that has the date values in SAS format

Re: Referencing a table that has a set of dates in SAS Date format that I want to convert to Date9.

ballardw — Thu, 25 Apr 2024 19:03:18 GMT

The DATEPART function assumes that you are extracting a Date value from a DATETIME value. DATETIME values are numbers of seconds and dates are numbers of days. So when you apply the Datepart to a date you get a very much smaller result. Basically any date between 01JAN1960 and 20JUL2196 will return a "datepart" value of 01JAN1960.

Your numeric value of 23480 is 14APR2024. So applying datepart to it will result in 01JAN1960.

So you apparently have date values and using Datepart is not wanted or needed. Just apply the date9. format to that variable.

Re: Referencing a table that has a set of dates in SAS Date format that I want to convert to Date9.

Jyuen204 — Thu, 25 Apr 2024 18:51:25 GMT

Thank you, that worked. I wasnt aware that was what the function was doing. Appreciate the guidance.

Re: Referencing a table that has a set of dates in SAS Date format that I want to convert to Date9.

ballardw — Thu, 25 Apr 2024 19:04:06 GMT

https://communities.sas.com/t5/SAS-Communities-Library/Working-with-Dates-and-Times-in-SAS-Tutorial/ta-p/424354 has a PDF with much information about dates you may find helpful.