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/
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.
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.
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.
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.
Registration is now open for SAS Innovate 2025 , our biggest and most exciting global event of the year! Join us in Orlando, FL, May 6-9.
Sign up by Dec. 31 to get the 2024 rate of just $495.
Register now!
Ready to level-up your skills? Choose your own adventure.