topic Re: holevalue of sgpie format in SAS Enterprise Guide

holevalue of sgpie format

szzzdhrd — Fri, 24 Sep 2021 14:23:26 GMT

I am using "proc sgpie" for a donut chart with the holevalue of 12345, but it is displayed as 12K. Is there a way to change the format of sisplay of that number in the middle of donut?

Re: holevalue of sgpie format

sbxkoenk — Fri, 24 Sep 2021 14:48:23 GMT

Just FYI : I cannot find a way but maybe others can??

HOLEVALUE <=number>

displays a numeric value inside the donut hole. If you specify a number, then that number is displayed inside the donut hole. If you do not specify a number, then the sum of the pie slices is displayed inside the donut hole.

Tip	The label for large values uses a condensed business format to abbreviate numerical values. For example, 1,100,000,000 is displayed as 1.1B. This format can cause you to lose precision, as it rounds values to improve the display within the hole area.

Re: holevalue of sgpie format

szzzdhrd — Fri, 24 Sep 2021 14:58:29 GMT

Thank you for getting back to me. Sorry if it was not clear, I want that sum of the pie slice, that is correct, but I want to see it as full like 12345 and not as a round12K. So i need to change the display format.

Re: holevalue of sgpie format

sbxkoenk — Fri, 24 Sep 2021 15:14:03 GMT

Hello,

I know. 😔

Although it is unusual to reply with a non-answer, as I have done, I simply wanted to indicate that to my knowledge it is not possible, but I do not want to stop others from trying it either.

Koen

Re: holevalue of sgpie format

sbxkoenk — Fri, 24 Sep 2021 15:30:37 GMT

Hello,

If no decent answer by tomorrow evening I will move this topic to the :

Programming > Graphics Programming board.

That's where all the graphical specialists are.

Koen

Re: holevalue of sgpie format

ballardw — Fri, 24 Sep 2021 21:21:27 GMT

@szzzdhrd wrote:
Thank you for getting back to me. Sorry if it was not clear, I want that sum of the pie slice, that is correct, but I want to see it as full like 12345 and not as a round12K. So i need to change the display format.

What format is currently assigned to the variable being used? Try adding a: Format thatvariablename f5.; to the proc and see it that helps. Possibly a long shot in view of this note from the documentation:

Tip The label for large values uses a condensed business format to abbreviate numerical values. For example, 1,100,000,000 is displayed as 1.1B. This format can cause you to lose precision, as it rounds values to improve the display within the hole area.

Typically I would also suggest considering changing text size but the documentation seems to say that is not (currently) available with the HOLEVALUEATTRS or HOLELABELATTRS. Perhaps you can find a font family that is smaller than currently used by your ODS Style. The font size seems limited by the hole size. Which bring up the next point:

And how much space is available in the "hole"? If the space looks small you may need to increase the size of the graph and/or hole to allow more digits.