topic Exporting to Excel and data changes to dates in SAS Programming https://communities.sas.com/t5/SAS-Programming/Exporting-to-Excel-and-data-changes-to-dates/m-p/151102#M298093 <HTML><HEAD></HEAD><BODY><P>I am using ODS to export to excel but after I export and open my file, some of my codes are dates. </P><P>For example, I have a code 11-2021, and it turns to Nov-2021.&nbsp; I don't want dates, I want my code to stay the same.&nbsp; How do I make it NOT turn to a date. </P><P><SPAN style="font-size: 10pt; font-family: Courier New;">Jessica </SPAN></P></BODY></HTML> Thu, 23 Jan 2014 22:49:46 GMT jjguillory 2014-01-23T22:49:46Z Exporting to Excel and data changes to dates https://communities.sas.com/t5/SAS-Programming/Exporting-to-Excel-and-data-changes-to-dates/m-p/151102#M298093 <HTML><HEAD></HEAD><BODY><P>I am using ODS to export to excel but after I export and open my file, some of my codes are dates. </P><P>For example, I have a code 11-2021, and it turns to Nov-2021.&nbsp; I don't want dates, I want my code to stay the same.&nbsp; How do I make it NOT turn to a date. </P><P><SPAN style="font-size: 10pt; font-family: Courier New;">Jessica </SPAN></P></BODY></HTML> Thu, 23 Jan 2014 22:49:46 GMT https://communities.sas.com/t5/SAS-Programming/Exporting-to-Excel-and-data-changes-to-dates/m-p/151102#M298093 jjguillory 2014-01-23T22:49:46Z Re: Exporting to Excel and data changes to dates https://communities.sas.com/t5/SAS-Programming/Exporting-to-Excel-and-data-changes-to-dates/m-p/151103#M298094 <HTML><HEAD></HEAD><BODY><P>Can you use tagattr something like this</P><P></P><P>style data_Text&nbsp;&nbsp; from data&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; /&nbsp; just=center tagattr='format:Text';</P><P></P><P>Maybe not centered</P></BODY></HTML> Thu, 23 Jan 2014 23:39:10 GMT https://communities.sas.com/t5/SAS-Programming/Exporting-to-Excel-and-data-changes-to-dates/m-p/151103#M298094 data_null__ 2014-01-23T23:39:10Z