proc report-merge cells of categories

[Ronein]

Hello

I want to use proc report to display a summary table.

My question is how to merge cels with same Cat2 value into one cell?

It is important to keep the order of the rows same as in the summary table .

Data summaryinfo;
input Cat $ Cat2 $ reduce Customers;
cards;
e group1 -500 200
b group1  -300 300
Total group1 -800 500
c group2 -250 400
a group2  -200 100
d group2  -100 150
Total group2 -550 650
;
run;
proc report data=summaryinfo nowd 
style(header)={background=lightgrey};
column Cat Cat2 reduce Customers;
Define Cat /display;
Define Cat2 /display;
Define reduce /display;
Define Customers /display;
Run;

[ed_sas_member]

Hi @Ronein 

Does the "GROUP" and 'SPANROWS' option meet your expectations?

proc report data=summaryinfo nowd spanrows style(header)={background=lightgrey};
	column Cat Cat2 reduce Customers;
	Define Cat /display;
	Define Cat2 /group style(column)={vjust=m just=l};
	Define reduce /display;
	Define Customers /display;
Run;