Export date into yyyy.mm.dd in an csv file

[hhchenfx]

Hello Everyone,

I have a dataset of Date as below and I want to export it to csv file with the format

yyyy.mm.dd

(you can ignore the time in the file).

Could you please help me?

Many thanks,

HHC

data have;

input date time;

informat time time11.;

format date date9. time time11.;

datalines;

20130730 4:00:00

20130130 5:15:00

[Kurt_Bremser]

In order to input into a SAS date, you have to assign a yymmdd8. informat to variable date.

You can then use yymmddp10. as output(display) format when you create the .csv.

[Reeza · Accepted solution]

Apply format yymmddp10. And then use PROC EXPORT. 

data out;

set have;

format date yymmddp10.;

run;

proc export data = out outfile='myfile.csv' DBMS=csv replace;run;