yyyy-mm-dd date format is lost when exporting into csv file

[Likhitha3]

Hello all,

I am trying to export a SAS data set into a CSV file using the proc export data step. The date format in the SAS data is yyyy-mm-dd. But in the CSV file it is getting converted into mm/dd/yyyy. 

I tried using the format statement YYMMDDd10., YYMMDD10., and even tried creating a new variable. But nothing is working. 

Can anyone please help me find the solution?

Thanks!

[Kurt_Bremser]

If you opened the file with Excel, Excel will apply its own format.

ALWAYS (as in ALWAYS) inspect csv files with a text editor.