DATA Step, Macro, Functions and more

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

Accepted Solution Solved
Reply
Super Contributor
Posts: 406
Accepted Solution

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

[ Edited ]

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


Accepted Solutions
Solution
‎12-25-2016 05:31 PM
Super User
Posts: 19,770

Re: Export date into yyyy.mm.dd in an scv file

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;

View solution in original post


All Replies
Super User
Posts: 7,762

Re: Export date into yyyy.mm.dd in an scv file

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.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
Solution
‎12-25-2016 05:31 PM
Super User
Posts: 19,770

Re: Export date into yyyy.mm.dd in an scv file

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;

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 601 views
  • 0 likes
  • 3 in conversation