topic How to fill the cells in a column in Proc Tabulate? in New SAS User

How to fill the cells in a column in Proc Tabulate?

mandonium — Fri, 15 Mar 2019 00:34:22 GMT

Hello,

I'm trying to produce reports in proc tabulate, but I need the output to have all the cells filled in.

This is what I get:

And this is what I want:

Here is my code:

proc tabulate data=ds01;
class var1 var2 var3 var4;
table var1 * var2 * var3, var4;
run;

Thank you!

Re: How to fill the cells in a column in Proc Tabulate?

Reeza — Fri, 15 Mar 2019 02:45:33 GMT

I don't think there's a way to do that in PROC TABULATE, but there should be in PROC REPORT. Or you can pre-summarize the data using PROC MEANS and display it using PROC REPORT or TABULATE.

@mandonium wrote:

Hello,

I'm trying to produce reports in proc tabulate, but I need the output to have all the cells filled in.

This is what I get:

And this is what I want:

Here is my code:
proc tabulate data=ds01;
class var1 var2 var3 var4;
table var1 * var2 * var3, var4;
run;
Thank you!

Re: How to fill the cells in a column in Proc Tabulate?

Ksharp — Fri, 15 Mar 2019 13:36:19 GMT

I don't know if there is such an option.

Maybe you should check documentation.

proc tabulate data=ds01;
class var1 var2 var3 var4;
table var1 * var2 * var3, var4/nocellmerge;
run;