topic EG-Multiple Summary Groupings possible in one step? in SAS Enterprise Guide

EG-Multiple Summary Groupings possible in one step?

crawfe — Fri, 18 Oct 2019 14:55:40 GMT

Hi, I am a relatively new EG user (moving to also use DI later this year hopefully so DI comments are welcome also).

I understand how to do a Summary Grouping of one variable (by Country-Site-Month etc.) using the bottom window.

Is it possible to do different summary groupings in a single step? It seems inefficient to have to

create a new step for every different group. For example, create columns for (group by) COUNT by Country-Site-Month and then COUNT by Country-Site in the same project step. Thanks!

Re: EG-Multiple Summary Groupings possible in one step?

TomKari — Fri, 18 Oct 2019 15:54:54 GMT

Boy have I got a task for you!

Here's an industrial-strength summarization engine, thanks to PROC MEANS.

From Enterprise Guide:

Open the dataset you want to summarize (I'm using SASHELP.SHOES as an example).
Select Describe -> Summary Statistics
On the Data tab, pull the variables you want to summarize into "Classification Variables". I used Region, Product, and Subsidiary.
On the Data tab, Pull one numeric variable into "Analysis Variables" (that's the only downside, you need one numeric variable, even though you don't use it for anything.) Make sure it's always non-null.
On the "Statistics" "Basic" tab, untick everything except "Number of Observations".
On the "Results" tab, untick "Show Statistics", and tick "Save statistics to data set". That will give you a summary dataset. Set "Combinations of classification variables" to "All ways".
Click "Run".

You'll get a dataset that will show all of the 0-way (summary for the dataset), 1-way (Region, and 2 others), 2-way (Region by Product, and two others) and 3-way (all three variables) summarizations of the data.

Tom

Re: EG-Multiple Summary Groupings possible in one step?

crawfe — Wed, 23 Oct 2019 12:18:35 GMT

That is pretty cool. For three columns, it gives you all possible two-way summaries also.

I am going to have to see how I can use it. Thanks!