topic Export date into yyyy.mm.dd in an csv file in SAS Programming

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

hhchenfx — Mon, 17 Oct 2016 18:35:54 GMT

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 — Sun, 16 Oct 2016 18:48:17 GMT

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 — Sun, 16 Oct 2016 18:51:24 GMT

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;