topic Re: proc tabulate in SAS Programming

proc tabulate

Ronein — Mon, 24 Aug 2020 06:29:12 GMT

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;

Re: proc tabulate

PeterClemmensen — Mon, 24 Aug 2020 06:40:54 GMT

Try this

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

Re: proc tabulate

Ronein — Mon, 24 Aug 2020 07:45:19 GMT

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

Re: proc tabulate

RichardDeVen — Mon, 24 Aug 2020 11:22:53 GMT

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.

Re: proc tabulate

Ronein — Thu, 27 Aug 2020 06:59:55 GMT

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.