Hiding rows in proc tabulate

[Pontch]

Hi guys,

I would like to format a proc tabulate report so that it display only rows where count(or n) is greater than 5.

The report currently has way to many rows and i would just like to make it smaller!

Is there any way to do that directly within a proc tabulate!

Many thanks in advance!

[PGStats · Accepted solution]

Not unless you already have a column containing the counts in your dataset. In which case you could simply add a WHERE dataset option clause to your tabulate input dataset.

PG

[Ksharp]

Or you can set the foregound of cell be the same color with background.That can hide some special  cell.

Ksharp

[Pontch]

Thanks guys, just wanted to know if that was possible but it does not seem to be the case, i am just doing the report in 2 steps from now on.

[ballardw]

Don't feel bad about 2 steps. I have lots of code where I pre-process data and use tabulate for display. I've even got code that takes tabulate output and massages it before using tabulate to make the final table because my clients want a certain look.