topic Re: How to cellmerge in excel in ODS and Base Reporting https://communities.sas.com/t5/ODS-and-Base-Reporting/How-to-cellmerge-in-excel/m-p/208351#M13816 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>As far as I am aware there is not method of doing this in tagsets.excelxp or libname excel.&nbsp; What I would suggest, as you seem to want to use a lot of Excel functionality, is to create a template Excel file, which has the layout you want.&nbsp; Export your data as CSV from SAS.&nbsp; Now, in your Excel file write a small VBA macro which opens and reads in the CSV file, and processes the data into the template.</P></BODY></HTML> Wed, 22 Jul 2015 08:15:04 GMT RW9 2015-07-22T08:15:04Z How to cellmerge in excel https://communities.sas.com/t5/ODS-and-Base-Reporting/How-to-cellmerge-in-excel/m-p/208350#M13815 <HTML><HEAD></HEAD><BODY><P>hi</P><P></P><P>i need to generate excel where one to six row should have 5 columns and seven to eleventh row last 3 columns should be merged into one column as shown in attachment</P><P></P><P><IMG alt="" class="jiveImage" src="https://communities.sas.com/legacyfs/online/11210_pastedImage_0.png" style="width: 661px; height: 351px;" /></P><BR /><IMG src="https://communities.sas.com/t5/image/serverpage/image-id/10886i961BE5347867297B/image-size/large?v=1.0&amp;px=600" border="0" alt="Excel output.jpg" title="Excel output.jpg" /></BODY></HTML> Wed, 22 Jul 2015 06:33:11 GMT https://communities.sas.com/t5/ODS-and-Base-Reporting/How-to-cellmerge-in-excel/m-p/208350#M13815 santhosh 2015-07-22T06:33:11Z Re: How to cellmerge in excel https://communities.sas.com/t5/ODS-and-Base-Reporting/How-to-cellmerge-in-excel/m-p/208351#M13816 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>As far as I am aware there is not method of doing this in tagsets.excelxp or libname excel.&nbsp; What I would suggest, as you seem to want to use a lot of Excel functionality, is to create a template Excel file, which has the layout you want.&nbsp; Export your data as CSV from SAS.&nbsp; Now, in your Excel file write a small VBA macro which opens and reads in the CSV file, and processes the data into the template.</P></BODY></HTML> Wed, 22 Jul 2015 08:15:04 GMT https://communities.sas.com/t5/ODS-and-Base-Reporting/How-to-cellmerge-in-excel/m-p/208351#M13816 RW9 2015-07-22T08:15:04Z Re: How to cellmerge in excel https://communities.sas.com/t5/ODS-and-Base-Reporting/How-to-cellmerge-in-excel/m-p/208352#M13817 <HTML><HEAD></HEAD><BODY><P>Is it possible to generate directly excel from sas ods</P></BODY></HTML> Thu, 23 Jul 2015 05:11:49 GMT https://communities.sas.com/t5/ODS-and-Base-Reporting/How-to-cellmerge-in-excel/m-p/208352#M13817 santhosh 2015-07-23T05:11:49Z Re: How to cellmerge in excel https://communities.sas.com/t5/ODS-and-Base-Reporting/How-to-cellmerge-in-excel/m-p/208353#M13818 <HTML><HEAD></HEAD><BODY><P>Yes, tagsets.excelxp, libname excel etc.&nbsp; Many ways to generate an Excel file from SAS.&nbsp; But they don't offer the functionality of cell merging.&nbsp; </P></BODY></HTML> Thu, 23 Jul 2015 07:50:31 GMT https://communities.sas.com/t5/ODS-and-Base-Reporting/How-to-cellmerge-in-excel/m-p/208353#M13818 RW9 2015-07-23T07:50:31Z