First I'll provide a link to information for working with dates and such that may be a good reference for later: https://communities.sas.com/t5/SAS-Communities-Library/Working-with-Dates-and-Times-in-SAS-Tutorial/ta-p/424354 has a PDF with much information about dates.
If you don't need the time portion you could use a data step with the DATEPART function to make the value a date and then the value would be a date and would accept the date9. or other date format.
Another approach is leave the value as datetime and value dispaly using a different format: DTDATE9. The DT, for datetime versions are available for some of the common date formats to display just the date portion of a datetime value.
The CSV you attached for this should not have imported as a datetime as there is no time portion shown unless there is something interesting about your set up. You don't mention which version or environment you use for SAS so you might be getting something from options set by an admin.
It is easy to copy text from a text editor (Notepad for example) and post it as part of the message windows using the </> for a text box. So we can see the text without downloading. Many users will not download files from unknown sources and since the browsers typically want to force CSV to open in a spreadsheet the shown results may vary.
Day of Date scaf,Project ID,FT Eload,FTEmedian,Surg Med,Surg Med Proc
31-Oct-20,ConnectCare_014,H2,M2,Surgery,Surgery
30-Oct-20,ConnectCare_014,H2,M2,Surgery,Surgery
29-Oct-20,ConnectCare_014,H2,M2,Surgery,Surgery
Another approach is to write a data step to read the csv. Then you control how the text is read and the format assigned.
Most of the common datetime layouts will read just the date portion if the proper informat is used.
If you have any control over the data I suggest not relying on two-digit years. I spent way too much time dealing with Y2K issues from such at one time.
Some "date" formats when using 2-digit years are extremely difficult to determine the content. Example: 010203 could be 1 Feb 2003 (or 1903), 2 January 2003, or 3 Feb 2001. And if a spreadsheet gets ahold of that and strips off the leading 0, leaving 10203 you might be looking a date of 22 July 2010 (Look up Julian Dates).
... View more