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,
Don H
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.
Test post
This is a test reply to see if notification system is working. Editing message here as a test.
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
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.