Desktop productivity for business analysts and programmers

Output with By Groups

Occasional Contributor RHL
Occasional Contributor
Posts: 9

Output with By Groups


I'm a new user of EG, and I've tried running PROCs and creating charts with by-groups. The output is indeed broken down by groups, but there are no labels to indicate which table or chart belongs to which value of the by-variable. Is there a way to show these labels?
Frequent Contributor
Posts: 80

Re: Output with By Groups


I had a quick go at this and when I do it I get a series of charts, each one showing the value of the By variable, so I am not sure which bit is causing you grief. Have a go at the steps I have outlined below and see if you get the demo to show what you want to see. I hope that I haven't mis-understood what your problem is.

I used SAS/Enterprise 4.1 to do this demo.

Please let the forum know how you progress with this.


Down-under Dave.
New Zealand

Open a brand new SAS/EG Project.
Open the Server List and expand the Libnames node until you see the SASHELP Libname.
Hint: If you cannot see the Server List or the Server List Tab, click on the menu View->Server List

Expand the SASHELP Libname. You should see lots of datasets, these are handy sample datasets that you can play with.
Drag the dataset called PRDSALE into your Project Process Flow

With the PRDSALE dataset node selected on the Process Flow, click on the menu Graph->Bar Chart....
In the wizard that appears choose the sort of chart you want, in this example choose a Simple Vertical Bar chart.

Click on the Task Roles entry in the left hand panel.
From the Columns to Assign box:
Drag DIVISION onto the Task Role labelled "Column to Chart (Limit: 1)"
Drag ACTUAL onto the Task Role labelled "Sum of (Limit: 1)"
Drag COUNTRY onto the Task Role labelled "Group charts by".

Click Run. You should now get a series of three (not very interesting!) charts, each one having a heading of Country=
Trusted Advisor
Posts: 2,127

Re: Output with By Groups

Using RTF and Word? If you are using Word's "normal view", you won't see the by group designation because it is in the section header. (I don't like it there because the header doesn't go with a cut-n-paste.).

Doc Muhlbaier
Occasional Contributor RHL
Occasional Contributor
Posts: 9

Re: Output with By Groups


I followed DaveShea's instructions and it worked out fine. I just went back to my original project and re-run it without changing anything and got the labels. So, I still don't know what went wrong in the first place, but thanks for the response.

Ask a Question
Discussion stats
  • 3 replies
  • 3 in conversation