topic Re: proc tabulate- 2 dimensional summary table in SAS Programming

proc tabulate- 2 dimensional summary table

Ronein — Wed, 19 Dec 2018 08:00:40 GMT

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;

Re: proc tabulate- 2 dimensional summary table

learsaas — Wed, 19 Dec 2018 08:29:49 GMT

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

Re: proc tabulate- 2 dimensional summary table

Ronein — Wed, 19 Dec 2018 09:10:26 GMT

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;

Re: proc tabulate- 2 dimensional summary table

Cynthia_sas — Wed, 19 Dec 2018 15:51:55 GMT

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

Re: proc tabulate- 2 dimensional summary table

ballardw — Wed, 19 Dec 2018 15:51:49 GMT

@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.