topic Re: Proc report - Merge grand total cells (or hide some) in SAS Programming

Proc report - Merge grand total cells (or hide some)

elsfy — Fri, 06 May 2022 14:51:49 GMT

Hi,

I am trying to customize my proc report.

I computed columns in order to get the total sum of observations.

The picture below shows the last line of my proc report with the total added.

The first three columns (var1--var3) refer to character variables and i want the total to be merged with the 2 cells on its left. Or alternatively, i though of hiding the two border lines shown in yellow.

Any help ?

proc report data = a ;

columns var1 var2 var3 ... ; 

define .. ; 
rbreak after / summarize ; 
compute after ;
var 3 = "Total" ; 
endcomp ; 
run ;

Re: Proc report - Merge grand total cells (or hide some)

Cynthia_sas — Fri, 06 May 2022 14:58:52 GMT

Hi:

PROC REPORT does not merge cells the way that Excel does. You can use a LINE statement, which would produce one line that would span the entire report (but then your Grand Totals wouldn't show in the columns. Or you could change to a style like JOURNAL, which suppresses interior table lines. You don't show all your code. What is your ODS destination of interest?

Cynthia

Re: Proc report - Merge grand total cells (or hide some)

elsfy — Fri, 06 May 2022 14:59:50 GMT

ODS EXCEL

Re: Proc report - Merge grand total cells (or hide some)

elsfy — Fri, 06 May 2022 15:03:59 GMT

If i understand correctly with the line statement i won't have the grand total with the sum of all next columns which is an absolute need.

Is it then possible to hide the borders in yellow like putting them in grey too?

Re: Proc report - Merge grand total cells (or hide some)

Cynthia_sas — Fri, 06 May 2022 15:20:56 GMT

Hi: Are there other changes in your code? How did you get the background grey? And the border lines in black? When I use the default ODS EXCEL style, my output for the TOTAL row is NOT grey and I don't have any borderlines. Did you show ALL your code including ODS style overrides? Are you using a custom style template? It maybe possible to change the border colors, but my experience with ODS EXCEL and borders is that EXCEL is very picky.
Cynthia

Re: Proc report - Merge grand total cells (or hide some)

elsfy — Fri, 06 May 2022 15:26:51 GMT

Actually my code is way more than that.

I did most of the customs with proc report just like that for instance ;

rbreak after / summarize  style(summary) = {font_weight=bold font_size=2 background=lightgrey just=r} ;

My idea was to hide the yellow borders with proc report but if it is possible with ods excel then it would be great.

Thank you for your help !

Re: Proc report - Merge grand total cells (or hide some)

Cynthia_sas — Fri, 06 May 2022 17:13:29 GMT

Hi:

Changing border styles worked for me using 9.4M7:

Cynthia