topic Re: Using FORMATS and INFORMAT of DATE VARIABLES solution as an attached document to open here. in SAS Software for Learning Community

Using FORMATS and INFORMAT of DATE VARIABLES

jbilenas — Sat, 08 Jul 2023 21:16:35 GMT

A SAS user asked in a SAS SLACK group, “I have a numeric value of 1686024000 and I need to change it to Datevalue”?

SAS SLACK group: https://app.slack.com/client/TA404MQKB/CA4L6S7SR/thread/CA4L6S7SR-1686075257.165029

I solved the solution for the SAS user in my SAS Blog and also posted it in my LinkedIn Profile:

Jonas V. Bilenas

SASATICIAN since 1986 in the Banking Industry.

https://jonasbilenascom.wpcomstaging.com/

Re: Using FORMATS and INFORMAT of DATE VARIABLES

Tom — Sun, 09 Jul 2023 03:16:16 GMT

Is there a question there?

I would be interested in know what date the value 1,686,024,000 turned out to be.

But not interested enough to click on the links.

Re: Using FORMATS and INFORMAT of DATE VARIABLES

jbilenas — Sun, 09 Jul 2023 14:10:36 GMT

OK. The Question was from a SAS User,

"“I have a numeric value of 1686024000 and I need to change it to Datevalue?”

He or She was using DATE FORMATS to convert the SAS date variable,1686024000, to a readable date. I will try to include my 6 page pdf solution.

Re: Using FORMATS and INFORMAT of DATE VARIABLES solution as an attached document to open here.

jbilenas — Sun, 09 Jul 2023 14:28:40 GMT

A SAS user would like to see my response here since the user did not want to click on the website links. I will attach the *.pdf file in this reply.

Re: Using FORMATS and INFORMAT of DATE VARIABLES

Tom — Sun, 09 Jul 2023 14:32:52 GMT

But what date value did they think that number represented?

It does not look like any digit string that would represent a date, so no need for any INFORMATs to convert strings into numbers.

It is clearly not a DATE value in SAS since that number of days would be past the year 5 million.

So perhaps they actually meant that they had a DATETIME value instead of DATE value.

In which case there is no need for 6 pages of PDF files.

700  data have ;
701    number=1686024000;
702    put number=datetime19. number=dtdate9.;
703  run;

number=05JUN2013:04:00:00 number=05JUN2013

If they thought it represented some other datetime value then perhaps it was using a different basis date than the 1960 that SAS uses.

Re: Using FORMATS and INFORMAT of DATE VARIABLES

jbilenas — Sun, 09 Jul 2023 15:29:08 GMT

That is correct but typically in training at SAS USER CONFERENCES, college training and corporate training, I like to add more that the conclusion is clear.

Interesting that you were able to get the date without using DATEPART function to separate the date component from the time component.

Thanks for showing me the DTDATE FORMAT.

With SAS training you always learn new things of getting solutions.

I guess I got used to Ron Cody's SAS training sessions since 1989 at many SAS USER GROUP MEETINGS I attended (local, regional, and national). The live presentations were very entertaining and encouraging one to keep learning and using SAS,

Jonas V. Bilenas

Jonas V. Bilenas.
local