The SAS Output Delivery System and reporting techniques

How to cellmerge in excel

Reply
Frequent Contributor
Posts: 85

How to cellmerge in excel

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


Excel output.jpg
Super User
Super User
Posts: 7,392

Re: How to cellmerge in excel

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.

Frequent Contributor
Posts: 85

Re: How to cellmerge in excel

Is it possible to generate directly excel from sas ods

Super User
Super User
Posts: 7,392

Re: How to cellmerge in excel

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. 

Ask a Question
Discussion stats
  • 3 replies
  • 400 views
  • 0 likes
  • 2 in conversation