Desktop productivity for business analysts and programmers

List Report vs Summary Tables (or proc report vs proc tabulate)

SAS Employee
Posts: 225

List Report vs Summary Tables (or proc report vs proc tabulate)

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!
Posts: 9,426

Re: List Report vs Summary Tables (or proc report vs proc tabulate)

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).

SAS Employee
Posts: 225

Re: List Report vs Summary Tables (or proc report vs proc tabulate)

Posted in reply to Cynthia_sas
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

Especially the google fight which tickled me so much I watched it 3 times!
Thanks again.
Ask a Question
Discussion stats
  • 2 replies
  • 2 in conversation