Grouping a barchart by unformatted values?

[andypandy_swe]

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?

[ballardw]

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.

[DanH_sas · Accepted solution]

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 

[andypandy_swe]

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.))"
...

[andypandy_swe]

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