topic How to fix this summary table? in SAS Enterprise Guide

How to fix this summary table?

ralizadeh — Thu, 15 Jun 2023 17:26:16 GMT

How do I get a total for each months in here? I've tried many ways and none worked so far.

I want to have something like this:

Re: How to fix this summary table?

Reeza — Thu, 15 Jun 2023 17:32:18 GMT

Use the ALL and put it under Pregnant row in the builder.
Or try it in a few different places until you get it where you need it 🙂

Re: How to fix this summary table?

ralizadeh — Thu, 15 Jun 2023 17:50:23 GMT

No, that doesn't work. I tried that before. I almost tried all the possible locations.

Re: How to fix this summary table?

Cynthia_sas — Thu, 22 Jun 2023 20:01:45 GMT

Hi:

I don't have the same data, but I used SASHELP.PRDSALE, which has a MONTH variable, which I used for the columns and the COUNTRY variable, which I used for the rows. In Enterprise Guide, taking all the defaults, this is the Summary Table I designed and the resulting table:

It's a little hard to describe the positioning. However, when you grab the ALL on the left side, when you drag it (the ALL term) over onto the table, you sort of have to not drop the ALL until you see a blue highlight under the COUNTRY box to get the ALL at the bottom and then you have to grab the ALL a second time and drag it over to the right side of MONTH until you see a blue highlight and then drop the ALL on the right side. This is one of those instances, when I find the Summary Tables task to be too fiddly for me and I prefer to write code, which allows more control (in my opinion) over the options, labels and style:

Hope this picture of my Summary Table helps.

Cynthia