08-07-2011 04:02 PM
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:
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,
08-07-2011 04:13 PM
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.