proc tabulate- 2 dimensional summary table

[Ronein]

Hello

I want to create 2 dimensional summary table.

What is the way to remove column with value " HORSEPOWER " and remove column with  value " Mean"  from output?

proc tabulate data=sashelp.cars ;
class ORIGIN TYPE ;
var  HORSEPOWER;
table TYPE*HORSEPOWER*mean, ORIGIN;
run;

[learsaas · Accepted solution]

table TYPE*HORSEPOWER=''*mean='', ORIGIN

[Ronein]

Thank you.

In your code solution I still see columns but they are empty.

How can I remove the columns?

proc tabulate data=sashelp.cars ;
class ORIGIN TYPE ;
var  HORSEPOWER;
table TYPE*HORSEPOWER=''*mean='', ORIGIN;
run;

[Cynthia_sas]

Hi:
change the TABLE statement
TABLE.... ORIGIN / row=float;
after ORIGIN and BEFORE the semi-colon.
Cynthia

[ballardw]

---

@Ronein wrote:

Thank you.

In your code solution I still see columns but they are empty.

How can I remove the columns?

proc tabulate data=sashelp.cars ;
class ORIGIN TYPE ;
var  HORSEPOWER;
table TYPE*HORSEPOWER=''*mean='', ORIGIN;
run;

---

Perhaps

proc tabulate data=sashelp.cars ;
   class ORIGIN TYPE ;
   var  HORSEPOWER;
   table TYPE*HORSEPOWER=''*mean='', 
         ORIGIN
         /row=float
   ;
run;

but the appearance with row=float can change depending on ODS destination.