I'm sending you a link to a post talking about conversion from Excel dates to SAS dates.   https://communities.sas.com/t5/SAS-Tips-from-the-Community/SAS-Tip-Conversion-from-Excel-Date-to-SAS-Date/td-p/475824   Maybe you can use  SAS_date = Excel_date - 21916;  to convert your Excel date to a SAS date.   Just one thing, you'll have to convert your character variable "date" to a numeric variable using INPUT (eg: numeric_date = input(date, 8.)) ... View more

Since I have almost no knowledge of Excel, explain what this function does. Don't assume I know what the problem is that this function solves. ... View more