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!
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
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
Or you can set the foregound of cell be the same color with background.That can hide some special cell.
Ksharp
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.
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.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.