topic Re: Exporting to Excel with format in SAS Enterprise Guide https://communities.sas.com/t5/SAS-Enterprise-Guide/Exporting-to-Excel-with-format/m-p/521166#M32671 <P>kindly refer below subject for solution</P><P>&nbsp;</P><P><SPAN>"How to retain the Variable Format when PROC EXPORT TO EXCEL"</SPAN></P><P>&nbsp;</P><P>Thanks,</P><P>Siva</P><P>&nbsp;</P> Thu, 13 Dec 2018 15:49:29 GMT sivastat08 2018-12-13T15:49:29Z Exporting to Excel with format https://communities.sas.com/t5/SAS-Enterprise-Guide/Exporting-to-Excel-with-format/m-p/189538#M14532 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>Am having a dataset where am calculating the percentages and when am trying to export it to excel by proc export the format is not the same as it was in sas for calculation.</P><P>Can anybody let me know how to keep the same format in excel ?</P><TABLE border="1" class="jiveBorder" style="BORDER-BOTTOM: #000000 1px solid; BORDER-LEFT: #000000 1px solid; WIDTH: 100%; BORDER-TOP: #000000 1px solid; BORDER-RIGHT: #000000 1px solid;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;"><STRONG>calculation in sas</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;"><STRONG>have format in excel</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;"><STRONG>want format in excel</STRONG></TH></TR><TR><TD style="padding: 2px;">60%</TD><TD style="padding: 2px;">0.60</TD><TD style="padding: 2px;">60%</TD></TR></TBODY></TABLE><P></P><P></P><P>Thanks in Advance!!!!</P></BODY></HTML> Mon, 19 Jan 2015 20:56:19 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Exporting-to-Excel-with-format/m-p/189538#M14532 rkolupoti9001 2015-01-19T20:56:19Z Re: Exporting to Excel with format https://communities.sas.com/t5/SAS-Enterprise-Guide/Exporting-to-Excel-with-format/m-p/189539#M14533 <HTML><HEAD></HEAD><BODY><P>Search on here for a variety of solutions <img id="smileyhappy" class="emoticon emoticon-smileyhappy" src="https://communities.sas.com/i/smilies/16x16_smiley-happy.png" alt="Smiley Happy" title="Smiley Happy" /></P></BODY></HTML> Mon, 19 Jan 2015 21:01:24 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Exporting-to-Excel-with-format/m-p/189539#M14533 Reeza 2015-01-19T21:01:24Z Re: Exporting to Excel with format https://communities.sas.com/t5/SAS-Enterprise-Guide/Exporting-to-Excel-with-format/m-p/521166#M32671 <P>kindly refer below subject for solution</P><P>&nbsp;</P><P><SPAN>"How to retain the Variable Format when PROC EXPORT TO EXCEL"</SPAN></P><P>&nbsp;</P><P>Thanks,</P><P>Siva</P><P>&nbsp;</P> Thu, 13 Dec 2018 15:49:29 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Exporting-to-Excel-with-format/m-p/521166#M32671 sivastat08 2018-12-13T15:49:29Z