BookmarkSubscribeRSS Feed
GemmaR
SAS Employee
Hello everyone,

I was just trying to find some information (or a white paper) on the differences between the list report and the summary tables task.

My colleagues are always 'debating' between proc report and proc tabulate and I wondered if this had taken over the Enterprise Guide world too.

Any comments on your favourite would be most welcome!
2 REPLIES 2
Cynthia_sas
SAS Super FREQ
Hi:
I don't know of a white paper that addresses the List Report Wizard versus the Summary Tables Task, specifically, but there are a bunch of PROC REPORT versus PROC TABULATE papers from previous user group meetings -- a few folks had an ongoing series about which was better. (If you Google search on the string: Battle Titans Report Tabulate
you should find the papers.)

The List Report Wizard in Enterprise Guide seems like a good "starter" code generator -- since it doesn't surface COMPUTE blocks the wizard is only doing simple summary reports or simple detail reports. The Summary Tables Wizard allows more nesting via drag and drop -- and more customization via the windows.

My personal tendency, for either procedure, is just to use code instead of the Wizards. I tend to prefer PROC REPORT (for the customizing, the COMPUTE block and the CALL DEFINE), but if I have a lot of slicing and dicing and nesting in my cross-tabs, then I prefer TABULATE.

But for the beginner, I think the biggest issue that I've heard about (and it surprised me) was whether they wanted the box area in the upper left hand corner of the table. For some folks, it doesn't matter that the BOX is there -- but I've had some students switch to PROC REPORT just because they didn't like the big empty box -- seriously -- the BOX area was a deal breaker for them -- they wanted the look that they got with PROC REPORT.

The second issue that I've heard about is changing the code -- some people find the PROC REPORT code easier to understand than the TABULATE code -- if and only if they have to change the code. The TABULATE code is more abbreviated and "algebra-like" with all the * and = in the TABLE statement. Even though the REPORT code is more verbose -- the existence of a COLUMN statement makes it clear which variable will come first on the report row, which second, which third, etc, etc. And then the explicit DEFINE statement makes it easy to see what statistic will get used for a numeric variable, the usage for a category variable (ORDER, GROUP or ACROSS).

cynthia
GemmaR
SAS Employee
Hi Cynthia,

Thank you so much for your reply.

T hee, I'm surprised about the Box area thing too! But I must agree and say that the code for PROC REPORT is so much easier to understand. I simply can't get my head around PROC TABULATE.

Thank goodness for Enterprise guide that will do all the complicated stuff at a click of the mouse!

Mind, I particulary enjoyed Chris Hemedingers blog
http://blogs.sas.com/sasdummy/index.php?/archives/212-PROC-REPORT-versus-TABULATE-two-SAS-heavyweigh...

Especially the google fight which tickled me so much I watched it 3 times!
Thanks again.

sas-innovate-white.png

Missed SAS Innovate in Orlando?

Catch the best of SAS Innovate 2025 — anytime, anywhere. Stream powerful keynotes, real-world demos, and game-changing insights from the world’s leading data and AI minds.

 

Register now

Creating Custom Steps in SAS Studio

Check out this tutorial series to learn how to build your own steps in SAS Studio.

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
  • 2 replies
  • 3282 views
  • 0 likes
  • 2 in conversation