Hi Emma2021,
After you import your Excel file into SAS table, you can clean up your DATE variable. Let's say, you imported your Excel file into SAS dataset HAVE. Then you can do the following manipulation to reconstruct your DATE:
data WANT;
set HAVE;
/* get day and month */
D = day(DATE);
M = month(DATE);
/* reconstruct your DATE */
DATE = mdy(M,D,2020);
run;
MDY() function calculates SAS date value out of Month, Day and Year.
Hope this helps.
... View more
