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
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;
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.
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;
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.