Is there a way to control how SAS reads in a variable when using the xlsx engine? I have an Excel file with a variable called "Date" that has a mix of date and date time values:
Date
2/5/2015
4/4/2016 11:10:00AM
3/23/2015
6/2/2015

When I use the libname xlxs engine, this is what the resulting SAS dataset looks like:
Date
42040
4/4/2016 11:10:00AM
42086
42157

This new SAS "Date" var is formatted as character ($21.), with the original date values as a SAS date, and the date time values as character. I don't mind if the SAS "Date" is character but I don't want it to convert the date values to SAS dates (want to keep as "2/5/2015" instead of "42040").

I have to do this for several Excel files with multiple sheets in each file, so want to have this process automated within a macro and not have to manually adjust any columns myself before using the xlsx engine... am I out of luck??