Hi, I have a dataset where variable 'Timestamp' has observations like
15189430314595
15443763999343
15443763999343
15486949615495
in a sequence. This is in nanoseconds as per the description of the database.
I want to convert these variables in date (mm/dd/yyyy) & time (hh:mm:ss) format.
Thanks in advance.
It is essential to know the cutoff timestamp (the moment when 0 nanoseconds were registered).
With this knowledge, you can do the calculation:
seconds = nanoseconds / 1000000000
and then correct for a zero-point that is different from the zero-point of SAS (01jan1960:00:00:00)
As your numbers are rather small, I suspect that you don't really have nanoseconds
(milli - 1/1000th
micro - 1/1000000
nano - 1/1000000000)
If your values were really nanoseconds, they would just describe a time value between 4:13:09 and 4:18:07. No datetimes here.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.