07-24-2017 07:46 AM
Hi, I have a dataset where variable 'Timestamp' has observations like
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.
07-24-2017 08:01 AM
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.