topic Re: Maintaining data formats from sas to excel using proc export in SAS Procedures https://communities.sas.com/t5/SAS-Procedures/Maintaining-data-formats-from-sas-to-excel-using-proc-export/m-p/131754#M35809 <HTML><HEAD></HEAD><BODY><P>Not with proc export no, the log says so.</P><P></P><P>Use tagsets.excelxp or another option.</P></BODY></HTML> Wed, 21 Nov 2012 16:50:34 GMT Reeza 2012-11-21T16:50:34Z Maintaining data formats from sas to excel using proc export https://communities.sas.com/t5/SAS-Procedures/Maintaining-data-formats-from-sas-to-excel-using-proc-export/m-p/131753#M35808 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P>I have a dataset with numeric variable _MONTH with values 1,2,3, etc... </P><P>I've applied a format so that 1="Jan", 2="Feb", 3="Mar", etc... for this variable within the sas dataset.</P><P></P><P>I'd like to export this sas dataset into excel using proc export but the variable _MONTH continues to display the actual numeric (1,2,3,etc.) values instead of the formatted (Jan, Feb, Mar,etc) values.&nbsp; Is there any way that I can maintain formats from the sas dataset into the excel file using proc export?</P><P></P><P>Thanks in advance for any suggestions,</P><P>Mackenzie</P></BODY></HTML> Wed, 21 Nov 2012 16:18:46 GMT https://communities.sas.com/t5/SAS-Procedures/Maintaining-data-formats-from-sas-to-excel-using-proc-export/m-p/131753#M35808 mweise 2012-11-21T16:18:46Z Re: Maintaining data formats from sas to excel using proc export https://communities.sas.com/t5/SAS-Procedures/Maintaining-data-formats-from-sas-to-excel-using-proc-export/m-p/131754#M35809 <HTML><HEAD></HEAD><BODY><P>Not with proc export no, the log says so.</P><P></P><P>Use tagsets.excelxp or another option.</P></BODY></HTML> Wed, 21 Nov 2012 16:50:34 GMT https://communities.sas.com/t5/SAS-Procedures/Maintaining-data-formats-from-sas-to-excel-using-proc-export/m-p/131754#M35809 Reeza 2012-11-21T16:50:34Z