Hi,
In base SAS 9.3, when combining date and time variables using dhms, the result creates phantom decimal places at the tail end of the datetime value. For example:
Time = 9:58:56.733220000 (format time18.9)
Date = 16APR2015
Datetime = dhms(date,0,0,time)
outputted datetime: 16APR2015:09:58:56.733220100 (format datetime28.9)
Interestingly, if I format Datetime variable as a number (e.g. 28.9), I don’t get the rounding issue: 1744797536.733220000. So I think it must be something to do with how SAS converts numbers to datetime.
Any suggestions are welcome. Thanks in advance!
Matt
... View more