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 !
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
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.
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
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 25. 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.