topic Re: style of grouped columns in SAS Programming

style of grouped columns

Konkordanz — Fri, 27 Jan 2023 11:39:53 GMT

Hi,

I want to group some columns as "test1" and "test" and want to colorize them differently and the font should be bold. But which is the easiest way to do that? Via google I found that: https://communities.sas.com/t5/SAS-Programming/proc-report-making-spanning-header-a-different-color/td-p/697169

But are dummy-variables really necessary? Is this way the only and best way to do that? That sounds pretty complicated to me.

Thank you!

proc report data=shoes(obs=3);
column ("test1"(region subsidiary)) ("test2"(product sales));
define region / display;
define subsidiary / display;
define product / display;
define sales / display;
run;

Re: style of grouped columns

ballardw — Fri, 27 Jan 2023 14:05:27 GMT

Without example data of what you have and the rules involved for exactly how to "colorize them differently" there really isn't any way to tell if dummy variables are needed.

So please describe what coloring you expect.

Re: style of grouped columns

Cynthia_sas — Fri, 27 Jan 2023 21:08:22 GMT

Hi:

I'm not entirely clear what you mean by grouping and colorizing. As you show them now, your test1 and test2 are just spanning headers so without some advanced technique, you only have one way to alter the style attributes of those header cells, as shown in #2 and #3.:

But if you want the headers for test1 and test2 to be the SAME as the other headers and columns, then you have to either use dummy variables (#4) or a technique like the user defined format in #5:

Since it is not entirely clear to me what you are trying to do, this is all I can envision at this point.

Cynthia

Re: style of grouped columns

Konkordanz — Mon, 30 Jan 2023 06:19:50 GMT

Right, sorry, I didnt set the dataset-step correctly. Thats the sample:

proc report data=sashelp.shoes(obs=3);
    column ("test1"(region subsidiary)) ("test2"(product sales));
	define region / display;
	define subsidiary / display;
	define product / display;
	define sales / display;
 run;

What I want is to colorize the spanning headers "test1" and "test2" differently. For example:

Re: style of grouped columns

Konkordanz — Mon, 30 Jan 2023 07:01:00 GMT

Thx for your answer. What I want is different colored spanning header. Something like that:

I tried a little bit around and the current result is this code with a strange result:

proc format;
	value $test
	"test1" = 'lightblue'
	"test2" = "grey"
	"Region" = "red";
run;	

/*=================================================================================================*/
/*Output-Optionen*/
ods excel file="." ;
/*=================================================================================================*/
 
proc report data=sashelp.shoes(obs=3) style(header)=[background=$test.];
    column ("test1"(region subsidiary)) ("test2"(product sales));
	define region / display;
	define subsidiary / display;
	define product / display;
	define sales / display;
 run;

After running this code SAS shows this result:

Right, no colors. But now I open it with Excel...

...and in Excel it shows the result I want:

Now my spanning headers are colored differently and I got the result without dummyvariables. But only within the excel output. Do you see a problem in my code?

Re: style of grouped columns

Kurt_Bremser — Mon, 30 Jan 2023 09:08:35 GMT

No problems. When I run your code on SAS on Demand without the Excel destination, I get this result:

Which main ODS destination do you use?

Re: style of grouped columns

Konkordanz — Mon, 30 Jan 2023 09:12:05 GMT

Sorry, but what means "main ODS destination"?

Re: style of grouped columns

Kurt_Bremser — Mon, 30 Jan 2023 09:53:54 GMT

It's what you select in the Results settings of your SAS interface (SAS Studio or Enterprise Guide). The default setting in SAS On Demand is HTML (in particular, HTML5).