How to cellmerge in excel

[santhosh]

hi

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

[RW9]

Hi,

As far as I am aware there is not method of doing this in tagsets.excelxp or libname excel.  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.  Export your data as CSV from SAS.  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.

[santhosh]

Is it possible to generate directly excel from sas ods

[RW9]

Yes, tagsets.excelxp, libname excel etc.  Many ways to generate an Excel file from SAS.  But they don't offer the functionality of cell merging.