Hello, I have imported an Excel (xlsx) dataset with 100+ variables, but one date variable refuses to be recognised as a date by SAS 9.4.  I have formatted it as a date in Excel, repeatedly done the 'text to columns' procedure to specify it is a date, and increased my guessingrows to well over the necessary amount.  I've also tried coping and pasting the values only in a new column, and repeated everything above, and still can't get it to work.  I get  NOTE: Invalid numeric data, date='12/27/2016' , at line xxxx column x for every date entry.   I am unable to convert the file to CSV as I lose data in other columns (in other languages).  The Excel file has many date variables and I can get them all to work except this one.  I've also tried formatting the variable in SAS but just get errors that the format cannot be loaded (Date9. or anything else) despite working fine in other procedures. Any thoughts on what I can do?   Thanks in advance ... View more