So a few points.
The variable you have does not have date values. It has datetime values. SAS stores dates as number of days and datetime as number of seconds. So to convert the value from a datetime value to a date value you need to divide by the number of seconds in a day. SAS provides a handy function, DATEPART(), that will do that for you.
If you want the value in the CSV file to be something that anyone looking at the CSV file will understand is a date then do not use a value like 20011101. That just looks like a number. Since there is no place in a CSV to store any metadata to indicate it isn't that number then most people (and programs) looking at the CSV file will assume it is just the number 20,011,101 instead of a date. It would be better to use something like 2001-11-01 instead. The hyphens will let the reader know it isn't a number. And displaying the date in YMD order will avoid the ambiguity caused by using either MDY or DMY order.
data for_export;
set have;
mydates=datepart(mydates);
format mydates yymmdd10.;
run;
proc export data=for_export file="want.csv" dbms=csv replace;
run;
And if actually have some consumer of the CSV file that requires that the dates be written in the file in that confusing YYYYMMDD style then you could leave the values as DATETIME values and just apply the E8601DN format to the variable.
... View more
