topic Re: Macro to create multiple sheet excel spread sheet in SAS Programming https://communities.sas.com/t5/SAS-Programming/Macro-to-create-multiple-sheet-excel-spread-sheet/m-p/162390#M31513 <HTML><HEAD></HEAD><BODY><P>Yes, if you have SAS 9.4 use ODS Excel.</P><P>If 9.3 or less try ODS Tagsets.ExcelXP</P><P>The demo has two examples, one data driven, one manual. This creates an XML file, not a native Excel file, but Excel will be able to read the file properly.</P><P></P><P><A href="http://support.sas.com/rnd/base/ods/odsmarkup/excelxp_demo.html" title="http://support.sas.com/rnd/base/ods/odsmarkup/excelxp_demo.html">Base SAS: Demo: ExcelXP Tagset and Microsoft Excel</A></P></BODY></HTML> Fri, 26 Sep 2014 21:23:51 GMT Reeza 2014-09-26T21:23:51Z Macro to create multiple sheet excel spread sheet https://communities.sas.com/t5/SAS-Programming/Macro-to-create-multiple-sheet-excel-spread-sheet/m-p/162389#M31512 <HTML><HEAD></HEAD><BODY><P>Does anyone have macro to create multiple sheet excel spread sheet report ?</P><P></P><P>Here is what I’m looking for. </P><P>Specify dataset names , list of columns and&nbsp;&nbsp; title statements and I will create multiple sheet for each table.&nbsp;&nbsp; Is it even possible? </P></BODY></HTML> Fri, 26 Sep 2014 21:18:03 GMT https://communities.sas.com/t5/SAS-Programming/Macro-to-create-multiple-sheet-excel-spread-sheet/m-p/162389#M31512 zqkal 2014-09-26T21:18:03Z Re: Macro to create multiple sheet excel spread sheet https://communities.sas.com/t5/SAS-Programming/Macro-to-create-multiple-sheet-excel-spread-sheet/m-p/162390#M31513 <HTML><HEAD></HEAD><BODY><P>Yes, if you have SAS 9.4 use ODS Excel.</P><P>If 9.3 or less try ODS Tagsets.ExcelXP</P><P>The demo has two examples, one data driven, one manual. This creates an XML file, not a native Excel file, but Excel will be able to read the file properly.</P><P></P><P><A href="http://support.sas.com/rnd/base/ods/odsmarkup/excelxp_demo.html" title="http://support.sas.com/rnd/base/ods/odsmarkup/excelxp_demo.html">Base SAS: Demo: ExcelXP Tagset and Microsoft Excel</A></P></BODY></HTML> Fri, 26 Sep 2014 21:23:51 GMT https://communities.sas.com/t5/SAS-Programming/Macro-to-create-multiple-sheet-excel-spread-sheet/m-p/162390#M31513 Reeza 2014-09-26T21:23:51Z Re: Macro to create multiple sheet excel spread sheet https://communities.sas.com/t5/SAS-Programming/Macro-to-create-multiple-sheet-excel-spread-sheet/m-p/162391#M31514 <HTML><HEAD></HEAD><BODY><P>Do you have example macro?</P></BODY></HTML> Fri, 26 Sep 2014 21:32:26 GMT https://communities.sas.com/t5/SAS-Programming/Macro-to-create-multiple-sheet-excel-spread-sheet/m-p/162391#M31514 zqkal 2014-09-26T21:32:26Z Re: Macro to create multiple sheet excel spread sheet https://communities.sas.com/t5/SAS-Programming/Macro-to-create-multiple-sheet-excel-spread-sheet/m-p/162392#M31515 <HTML><HEAD></HEAD><BODY><P>WWhy a macro? There's example code in the link. </P></BODY></HTML> Fri, 26 Sep 2014 21:49:04 GMT https://communities.sas.com/t5/SAS-Programming/Macro-to-create-multiple-sheet-excel-spread-sheet/m-p/162392#M31515 Reeza 2014-09-26T21:49:04Z