topic Hiding rows in proc tabulate in SAS Procedures

Hiding rows in proc tabulate

Pontch — Fri, 16 Mar 2012 17:50:58 GMT

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!

Hiding rows in proc tabulate

PGStats — Fri, 16 Mar 2012 18:00:22 GMT

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.

Hiding rows in proc tabulate

Ksharp — Mon, 19 Mar 2012 02:48:36 GMT

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

Ksharp

Hiding rows in proc tabulate

Pontch — Tue, 20 Mar 2012 14:22:00 GMT

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.

Hiding rows in proc tabulate

ballardw — Tue, 20 Mar 2012 20:42:49 GMT

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.