topic Re: Change the color with proc tabulate in SAS Programming

Change the color with proc tabulate

SASdevAnneMarie — Fri, 09 Jul 2021 10:14:29 GMT

Hello Experts,

I'm wondering how to change the color on yellow for 2 last columns with proc tabulate :

My code is :


data shoes;
	set sashelp.shoes (obs=20);
run;

ods excel file = "\\XXXXX\mon_fichier_2.xlsx"
	options(start_at = "2,2" 
	embedded_titles = "on"
	embed_footnotes_once = "on"
	autofilter = "1-9"
	frozen_headers = "on"
	frozen_rowheaders = "2"
	absolute_column_width = "15,15,15,15,15,15,15,15,15,15"
	row_heights = "15,15,15,15,15,15"
	sheet_name = "Tableau"
	tab_color = "yellow")
	style=Listing;

proc tabulate data=shoes;
	title "Question";
	class region product Subsidiary;

	table (Product ALL ='TOTAL1'), (product ALL='TOTAL2')(Subsidiary ALL='TOTAL3');
		keylabel n=' ';
run;

ods excel close;

How can I change also the grey color ?

Thank you ror your help !

Re: Change the color with proc tabulate

BrunoMueller — Fri, 09 Jul 2021 12:10:00 GMT

Have a look here in the doc to see how various elements can be colored
https://go.documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/proc/p0e7wgyk6rm3ppn1pny8b38napm3.htm

Or choose a different style.

Re: Change the color with proc tabulate

SASdevAnneMarie — Fri, 09 Jul 2021 14:07:35 GMT

Thank you, Bruno,
I put the color on "Abab", "Algiers" and "Cairo" with : Classlev Subsidiary / style= [background=lightgreen];
But still can't color "Subsidiary" end "TOTAL3".

Thank your for your help !

Re: Change the color with proc tabulate

ballardw — Fri, 09 Jul 2021 14:43:36 GMT

You really should show ALL the code.

Consider:

proc tabulate data=sashelp.shoes(obs=20);
	title "Question";
	class region product;
   class Subsidiary/style=[background=lightgreen];
   Classlev Subsidiary / style= [background=lightgreen];
	table (Product ALL ='TOTAL1'), 
         (product ALL='TOTAL2')(Subsidiary ALL=[label='Total 3' style=[background=lightgreen]] );
		keylabel n=' ';
run;

CLASSLEV assigns properties to the levels, i.e. values of a class variable. If you want to change the CLASS variable appearance that can go on a CLASS statement or an override.

ALL is not a value of the class variable so needs to be addressed separately in overrides.

Re: Change the color with proc tabulate

SASdevAnneMarie — Fri, 09 Jul 2021 14:53:32 GMT

Thank you Ballardw !
What is the difference between proc report and proc tabulate.
Maybe the proc report is better to use?

Re: Change the color with proc tabulate

ballardw — Fri, 09 Jul 2021 15:19:12 GMT

The main differences between Proc Tabulate and Proc Report the way that I use them (others may see things differently) is that Proc Tabulate handles nesting in both row and column dimensions with multiple variables a bit "nicer" and allows multiple table statements in a single procedure call. Proc Report has more control over some things calculated in the procedure like break line summaries, calculations between result columns and compute blocks can conditionally assign appearance a bit more flexibly, with additional concerns, than Tabulate.

Which to use depends on what you need.

Re: Change the color with proc tabulate

SASdevAnneMarie — Fri, 09 Jul 2021 15:51:49 GMT

Thank you, ballardw. Last question: do you know please some option to change the grey color ?

Re: Change the color with proc tabulate

ballardw — Fri, 09 Jul 2021 16:18:01 GMT

@SASdevAnneMarie wrote:
Thank you, ballardw. Last question: do you know please some option to change the grey color ?

The "grey color" where? The thing I find most challenging with some of these style elements is just finding the proper name to address them.

It may also help to mention which ODS Style you are using as a default or the the ODS destination as some of them default to different styles than the session setting.

For example I have my SAS sessions set to use the style MEADOW. Which has almost no grey anywhere.

Re: Change the color with proc tabulate

SASdevAnneMarie — Fri, 09 Jul 2021 16:56:43 GMT

Thank you, Ballardw. My ods style is style=Listing. I would like to change the color for blue, by default.

Re: Change the color with proc tabulate

BrunoMueller — Mon, 12 Jul 2021 12:22:23 GMT

I suggest you have a look at the ODS Style Gallery and pick the one that suits you best. Which style you choose also depends on the ODS destination you are using.

Also have a look at the SAS Note https://support.sas.com/techsup/notes/v8/36/900.html it provides a program that will show you some output created with all the styles, open the frame.html to view them all. The program will create a lot of files.

Re: Change the color with proc tabulate

SASdevAnneMarie — Wed, 14 Jul 2021 10:28:03 GMT

Thank you, Bruno !