BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
Pontch
Fluorite | Level 6

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!

1 ACCEPTED SOLUTION

Accepted Solutions
PGStats
Opal | Level 21

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

PG

View solution in original post

4 REPLIES 4
PGStats
Opal | Level 21

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

PG
Ksharp
Super User

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

Ksharp

Pontch
Fluorite | Level 6

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
Super User

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.

hackathon24-white-horiz.png

The 2025 SAS Hackathon Kicks Off on June 11!

Watch the live Hackathon Kickoff to get all the essential information about the SAS Hackathon—including how to join, how to participate, and expert tips for success.

YouTube LinkedIn

What is Bayesian Analysis?

Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 4 replies
  • 2955 views
  • 4 likes
  • 4 in conversation