topic Re: Grouping a barchart by unformatted values? in Graphics Programming

Grouping a barchart by unformatted values?

andypandy_swe — Tue, 09 Feb 2021 11:07:38 GMT

I'm grouping a barchartparm by sites in four groups.

leaf node site, parent, that parent's parent, and Nation.

All sites have unique ID's but from time to time two unique ID's have the same label. So a leaf node might have ID=12345 and have the label 'Mysite' and it's parent site with ID=98765 might also have the label 'Mysite'.

When I send the data to a barchartparm template, of course the two groups are merged into one (and SAS issues a warning). And so I get only three groups instead of four.

Is there a way to get the barchartparm to recognize that they're two different groups (to look at the ID instead of the label of the ID variable) ? If not, is there a workaround so that i can present all four groups and have two of them shown with the same name?

Re: Grouping a barchart by unformatted values?

ballardw — Tue, 09 Feb 2021 14:59:42 GMT

At least show the code you are currently attempting so we know all the options you are using.

That may help.

But since your data has the same value for a variable you may need to modify the data.

Re: Grouping a barchart by unformatted values?

DanH_sas — Tue, 09 Feb 2021 15:27:22 GMT

In your user-defined format, try adding this label twice but add a leading <space> to one of them. Then, assign one the unique values to these labels.

Hope this helps!

Dan

Re: Grouping a barchart by unformatted values?

andypandy_swe — Tue, 09 Feb 2021 15:55:18 GMT

Thank you both but I just solved it. For one of the four levels (one of the two that has the possibility of getting the same label) I added a right-align to the putc() -function in my proc format.
This makes the barchartparm template recognize it as a separate group and when the groups are listed in the legend of the graph, it isn't right aligned anymore so it looks just the way I want it.

proc format library=save.session_formats;
value $unit_output
...
'2_STEPS_DOWN'="%sysfunc(putc(&ADMINISTRATIVE_UNIT, $ORG_UNIT_NAME. -r))"
'3_STEPS_DOWN'="%sysfunc(putc(&UNIT, $ORG_UNIT_NAME.))"
...

Re: Grouping a barchart by unformatted values?

andypandy_swe — Tue, 09 Feb 2021 15:56:56 GMT

I guess my solution is pretty much what you suggested Dan...