proc tabulate : options for N

[SASdevAnneMarie]

Hello Experts,

I'm wondering how to delete the "N" in table generated with the proc tabulate :

My code is :

proc tabulate data=ma_table;
	title "Tableau";
	class COM TYPE_COM DEV;
	table (TYPE_COM ALL ='TOTAL1'), (COM 
        ALL='TOTAL2')(DEV ALL='TOTAL3');
run;

Thank you !

[ballardw]

One way is to make sure that you include the statistic requested in the table statement(s). Then you can use an override to suppress a specific label: variable*n=' ' 

or use the Keylabel statement to provide the same behavior for all uses of the statistic:

Keylabel n=' ';

If the statistic occurs in a row you may need/want to use the table option /row=float; as some destinations will have "phantom" boxes where the label was suppressed.

[Cynthia_sas · Accepted solution]

Hi:

  To change or get rid of the label for a statistic, you need to use the KEYLABEL statement:

  If you wanted to suppress the label for Region, you'd have to do this in the TABLE statement:

  I used SASHELP.SHOES for my example, since you did not post any data. I used only one variable in the column dimension just to illustrate how to change the labels.

Cynthia