topic Re: Changing date format from YYMM7. to MMDDYY10. in SAS Procedures

Changing date format from YYMM7. to MMDDYY10.

Juli13 — Fri, 18 Aug 2017 17:03:59 GMT

I have a SAS dataset with a variable named cars in YYMM7. format and I want to convert it to MMDDYY10. format. Please suggest the complete code to do so. This is what i have so far-

%let path=C:\Users\AB\Documents\My SAS Files\9.4;
libname abcd "&path";
ods HTML file="C:\Users\AB\Documents\My SAS Files\9.4\line.xls";
proc print data=abcd.line;
run;
ods HTML close;

I am using a sas dataset to create an excel file and I need the date of the variable cars changed from YYMM7. to MMDDYY10. format.

Re: Changing date format from YYMM7. to MMDDYY10.

Kurt_Bremser — Fri, 18 Aug 2017 17:11:21 GMT

Post example data, in a data step so we can see the variable attributes. From your post, it is not clear if you have a SAS date variable or a string.

Re: Changing date format from YYMM7. to MMDDYY10.

Reeza — Fri, 18 Aug 2017 17:59:12 GMT

You shouldn't use ODS HTML to create an Excel file, unless you're on really old versions of SAS IMO.

%let path=C:\Users\AB\Documents\My SAS Files\9.4; 

libname abcd "&path";

ods Excel file="C:\Users\AB\Documents\My SAS Files\9.4\line.xlsx";

proc print data=abcd.line;

format cars mmddyy10.;

run;

ods excel close;

Re: Changing date format from YYMM7. to MMDDYY10.

Juli13 — Fri, 18 Aug 2017 18:03:36 GMT

2017M06

2015M10

2014M06

2014M03

2014M06

above is an example of the various observations in the variable that I want to change to the following format-

7/1/2012

10/1/2013

10/1/2012

4/1/2012

Re: Changing date format from YYMM7. to MMDDYY10.

Juli13 — Fri, 18 Aug 2017 18:04:21 GMT

what do you suggest for creating an excel file from SAS dataset?

Re: Changing date format from YYMM7. to MMDDYY10.

Reeza — Fri, 18 Aug 2017 18:34:26 GMT

Proc export or ODS EXCEL. I even wrote the code for one of those...

Re: Changing date format from YYMM7. to MMDDYY10.

Juli13 — Fri, 18 Aug 2017 18:53:41 GMT

Thank you so much Reeza! 🙂

Re: Changing date format from YYMM7. to MMDDYY10.

Juli13 — Mon, 28 Aug 2017 20:38:09 GMT

what is the code for proc export?

Re: Changing date format from YYMM7. to MMDDYY10.

Reeza — Tue, 29 Aug 2017 00:56:01 GMT

Here's an old blog post that has sample code and several methods.

http://blogs.sas.com/content/sasdummy/2012/02/11/export-excel-methods/

Re: Changing date format from YYMM7. to MMDDYY10.

Juli13 — Tue, 29 Aug 2017 01:52:21 GMT

Thanks Reeza! Incredibly helpful!