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;