Stack multiple cells of excel using ODS - SAS

162 views Asked by At

For example, I have a table like this:

A   N  
A   Mean 
A   Min 
A   Max

I'm using ODS tagsets.excelXP to export this data to Excel. In Excel, i don't want my first column to repeat "A" 4 times. I want to fuse the 4 rows of this column. Basically,i want a big cell containing the value A.

     N
  A  Mean
     Min
     Max

Can you tell me how to do that please?

Update:

For the rows fusion, i did this:

proc report data=... spanrows;

define A/order; (delete the duplicated rows of the variable A)

run;

0

There are 0 answers