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 2025: Call for Content

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!

Submit your idea!

SAS Enterprise Guide vs. SAS Studio

What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 2 replies
  • 2862 views
  • 0 likes
  • 2 in conversation