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

[mandonium]

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!

[Reeza]

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!

---

[Ksharp]

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;