Hi All, I have a problem that I have research many different ways. I'm trying to import an excel spreadsheet that contains a date field that is customized as such 1/14/2018 10:43:00 AM which is the variable 'e' below. I imported the data using a libname, an import proc and also added options to the import with no success . The problem is as follows Here's the code. data fix; set sr222; x=e; dt1 = dhms(x,0,0,0); format dt1 datetime20.: run: It converts that variable okay but SAS is adding to the date. For example: incoming date = 1/5/2018 3:10:00 PM conversion date = 06JAN2078:15:10:00 can anybody please help
... View more