topic Writing Output To Excel With Formulas in SAS Procedures https://communities.sas.com/t5/SAS-Procedures/Writing-Output-To-Excel-With-Formulas/m-p/62568#M17795 <HTML><HEAD></HEAD><BODY><P>Are you using 32-bit or 64-bit version of AIX?</P></BODY></HTML> Fri, 09 Sep 2011 18:17:25 GMT FriedEgg 2011-09-09T18:17:25Z Writing Output To Excel With Formulas https://communities.sas.com/t5/SAS-Procedures/Writing-Output-To-Excel-With-Formulas/m-p/62567#M17794 <HTML><HEAD></HEAD><BODY><P>We have a bunch of EG SAS jobs that write out *.csv files, no problem there.</P><P>We are now looking to write the output into an existing blank (template) *.xls sheets.</P><P>The xls sheet has a lot of formula's within it, we can not seem to write the data into a cell and retain the formula.</P><P>Any ideas?</P><P></P><P>SAS Enterprise Guide 4.1 (4.1.0.1019)</P><P>AIX UNIX</P><P></P><P>TIA</P><P>Jay</P></BODY></HTML> Fri, 09 Sep 2011 17:25:15 GMT https://communities.sas.com/t5/SAS-Procedures/Writing-Output-To-Excel-With-Formulas/m-p/62567#M17794 JaySwan 2011-09-09T17:25:15Z Writing Output To Excel With Formulas https://communities.sas.com/t5/SAS-Procedures/Writing-Output-To-Excel-With-Formulas/m-p/62568#M17795 <HTML><HEAD></HEAD><BODY><P>Are you using 32-bit or 64-bit version of AIX?</P></BODY></HTML> Fri, 09 Sep 2011 18:17:25 GMT https://communities.sas.com/t5/SAS-Procedures/Writing-Output-To-Excel-With-Formulas/m-p/62568#M17795 FriedEgg 2011-09-09T18:17:25Z Writing Output To Excel With Formulas https://communities.sas.com/t5/SAS-Procedures/Writing-Output-To-Excel-With-Formulas/m-p/62569#M17796 <HTML><HEAD></HEAD><BODY><P> 64</P></BODY></HTML> Fri, 09 Sep 2011 23:34:47 GMT https://communities.sas.com/t5/SAS-Procedures/Writing-Output-To-Excel-With-Formulas/m-p/62569#M17796 JaySwan 2011-09-09T23:34:47Z Re: Writing Output To Excel With Formulas https://communities.sas.com/t5/SAS-Procedures/Writing-Output-To-Excel-With-Formulas/m-p/62570#M17797 <HTML><HEAD></HEAD><BODY><P>I would look into proc template and ods tagsets to create an html document for excel to read.</P><P></P><P><A href="http://support.sas.com/rnd/base/ods/excel/index.html">http://support.sas.com/rnd/base/ods/excel/index.html</A></P></BODY></HTML> Sat, 10 Sep 2011 00:26:58 GMT https://communities.sas.com/t5/SAS-Procedures/Writing-Output-To-Excel-With-Formulas/m-p/62570#M17797 FriedEgg 2011-09-10T00:26:58Z