I imported an excel file with date information enclosed as a format of mm/dd/yyyy hh:ss  (e.g. 08/24/2022 14:09) in Excel. After importing into SAS, the format changed automatically into a series of numbers and variable type is character. I converted numeric variables into dates using datepart and DATE9. format. However, I got the different date for the same record. e.g. 08/24/2022 14:09 changed to 25AUG2082.   I would like to keep the original date information and format. Does anyone know how this can be done? I've tried input/put and datepart functions.  ... View more