Trying to convert date formats when I am importing an Excel 2010 worksheet. Am using LIBNAME engine to import worksheet in which "Date_Effective" column is in a datetime type Excel format. Code is: libname xl XLSX "C:\ROSTER.xlsx"; data ROSTER_IN; set xl.'sheet2015$'n(SASDATEFMT=(Date_Effective=MMDDYY8.); run; from log... set xl.'sheet2015$'n(SASDATEFMT=(Date_Effective=MMDDYY8.)); ---------- 22 ERROR 22-7: Invalid option name SASDATEFMT. Thought option SASDATEFMT was ok to use with Excel2010 files. Any thoughts on how to fix problem?
... View more