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 ;
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
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?
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 !
Hi:
Changing border styles worked for me using 9.4M7:
Cynthia
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 16. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Select SAS Training centers are offering in-person courses. View upcoming courses for: