Desktop productivity for business analysts and programmers

Listing Results from a Summary Step

Reply
Frequent Contributor
Posts: 148

Listing Results from a Summary Step

Let me start by emphasizing that I am a long-time SAS user/programmer and so perhaps I am not thinking about this the way in need to in the EG universe.

Here is what I need to do:

  1. Query some data (got that with the Query Builder task - NP)
  2. Create summaries (got that with the Summary Statisitics task - again NP)
  3. List the results - and here is where the problem is.

So here is my issue. I need to do two things. Specify/control the labels and select certain columsn to be summed. But these two requirements, which I can do pretty easily in PROC PRINT or PROC REPORT don't seem to work as I'd expect.

I first tried the List Data task and it does most of what I want - but it does not allow me to customize the headers. Since the data comes from an external DB both the column name and the label which is the same as the column name are long and have underscores. The list data task however does not include _ as one of the allowable split characters. Given how common the use of _ as a split character is in SAS programs, I am hoping I am missing something obvious.

So I next tried the List Report Wizard task. That allowed me to customize the headers. But it also put the statistic (e.g., SUM) in every header. The only way I found to suppress this was to say display all values for each column. But if I do that, the task excludes the column from being summarized at the bottom of the report.

What I want is an incredibly simple SAS program using SUMMARY/MEANS with PRINT/REPORT. I only need to do this in EG as the users/client are not programmers and they don't want to have to write code. They point a point-and-click interface.

TIA for any suggestions,

Don H

Frequent Contributor
Posts: 148

Listing Results from a Summary Step

Two more things that I forgot to mention.

First, I also tried to provide labels as part of the Query Builder task. And those did carry thru and could be used by the List Data task. But the Summary Statistics task appends _SUM to the label and I don't see any way to get rid of that.

Second, this is EG 4.3 using a BI/EBI server environment.

Community Manager
Posts: 291

Re: Listing Results from a Summary Step

Test post

Community Manager
Posts: 291

Re: Listing Results from a Summary Step

This is a test reply to see if notification system is working. Editing message here as a test.

Ask a Question
Discussion stats
  • 3 replies
  • 148 views
  • 0 likes
  • 2 in conversation