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

Likhitha3 — Sat, 19 Mar 2022 17:08:04 GMT

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!

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

Kurt_Bremser — Sat, 19 Mar 2022 17:16:00 GMT

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

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

topic Re: yyyy-mm-dd date format is lost when exporting into csv file in SAS Programming

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

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