proc report-merge cells of categories

Ronein — Wed, 11 Mar 2020 09:26:28 GMT

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;

Re: proc report-merge cells of categories

ed_sas_member — Wed, 11 Mar 2020 09:33:34 GMT

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;

topic proc report-merge cells of categories in SAS Programming

proc report-merge cells of categories

Re: proc report-merge cells of categories