The difference between what you have coming in, and what you're getting, is simply the difference between SAS datetimes and Excel datetimes. One represents the number of seconds since Jan 1, 1900, while the other (SAS) represents the number of seconds since Jan 1, 1960.
To convert the datetimes you can use code like:
data fix;
set sr222;
dt1 = e-21916*86400;
format dt1 datetime20.:
run:
Art, CEO, AnalystFinder.com
... View more