topic proc tabulate : options for N in SAS Programming

proc tabulate : options for N

SASdevAnneMarie — Thu, 08 Jul 2021 15:16:57 GMT

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 !

Re: proc tabulate : options for N

ballardw — Thu, 08 Jul 2021 15:44:45 GMT

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.

Re: proc tabulate : options for N

Cynthia_sas — Sat, 10 Jul 2021 16:00:54 GMT

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