proc tabulate

[Ronein]

Hello

What is the way that the value under "Type" variable will be in each row of the report ?

I want to see in each row the value of "Type" var

proc tabulate data=sashelp.cars;
class type Cylinders;
var Invoice;
Table type=""*Cylinders='',Invoice*(N SUM) /box='Type/Cylinders';
Run;

[PeterClemmensen]

Try this

proc tabulate data=sashelp.cars;
class type Cylinders;
var Invoice;
Table Cylinders=''*type="",Invoice*(N SUM) /box='Type/Cylinders';
Run;

[Ronein]

Thank you but it is not as I want.
I want that for both class variables I will see the value in each row

[RichardDeVen]

Proc REPORT can present the data the same way as in TABULATE, with the extra caveat of filling in the 'blank' cells.

By default a group cell is blank in subsequent row after it is presented the first time.  COMPUTE blocks can be used to track and replace the blank (missing) values with the current group value.

Example:

proc report data=sashelp.cars;
  columns type cylinders invoice,(n sum);
  define type / group;
  define cylinders / group;
  define n / format=8.;
  compute before type;
    type_held = type;
  endcomp;
  compute type;
    if missing(type) then type=type_held;
  endcomp;
run;

REPORT output:

Versus TABULATE output:

You can get the same aggregation output from Proc MEANS

proc means data=sashelp.cars noNOBS N SUM ;
  class type cylinders;
  var invoice;
run;

The default output does not repeat the type values.

[Ronein]

I have asked how to create the desired output via proc tabulate ....
Thank you for the answer but I wanted to understand how to see values of class variables in each row via proc tabulate.