topic Re: vbar: sum inside bar, rotated and diffent color in Graphics Programming

vbar: sum inside bar, rotated and diffent color

Eva — Thu, 13 Dec 2012 13:18:13 GMT

Dear all,

I have a vbar chart with sums of each bar that are displayed inside the bar:

proc gchart data=mydata;

vbar year / sumvar = mysum

group = quartal

type = sum

inside = sum /* that's how the sum is shown inside the bar instead of on top */

discrete;

run;

quit;

That's ok. But now I'd like to rotate the sum by 90 degrees and print them in white font color. And: the sums should be valign center inside the bars. How can I do this?

that's how it should look like:

Best wishes

Eva

Re: vbar: sum inside bar, rotated and diffent color

AncaTilea — Thu, 13 Dec 2012 13:46:41 GMT

Hi.

Probably using annotate. I am not aware of the inside statement to allow for angle, but it may.

Below is a poorly written piece of code (just a bad programming day) but it gets what you want done.

Since I didn't have a sample data, I used sashelp.class; the idea is that instead of using "inside = sum" statement in your PROC GHART, you use an annotate data set to place the SUMs where you want them.

/*calculate the sums needed to place on the bars*/

proc summary data = sashelp.class print sum;

var weight;

class sex;

ods output Summary = sum;

run;

/*bring the SUMs over to your original data set - there is a quicker and better way of doing this, but now the brain doesn't work*/

proc sort data = sum;by sex;

proc sort data = sashelp.class out = temp;by sex;

data for_anno;

merge temp sum;

by sex;

run;

/*create the annotate data set*/

data anno;

set for_anno;

retain xsys ysys "2" hsys "3" when "a" ;

function = "label"; color = "black" ;style = '"Times New Roman/bold"' ;

size = 2.7 ;color = "White";angle = 90;

text = put(weight_sum, 6.0);midpoint = sex ;x = weight; y = 345;output;

run;

proc gchart data=sashelp.class anno = anno;

vbar sex / sumvar = weight

type = sum

discrete;

run;quit;

Good luck.

If things work horribly, please provide some sample data.

Anca.

Re: vbar: sum inside bar, rotated and diffent color

Eva — Thu, 13 Dec 2012 13:55:24 GMT

Dear Anca,

thanx for your code. The problem is that I don't yet know annotate. Is there maybe a simpler solution within the proc gchart procedure?

Best wishes,

Eva

Re: vbar: sum inside bar, rotated and diffent color

AncaTilea — Thu, 13 Dec 2012 14:19:06 GMT

Hi Eva.

I am not aware of ways to manipulate the "inside" statement (which is what you'd need to do).

If you try the annotate code, you shall see it is not as bad.

And annotate can be quite powerful.

Best of luck.

Anca.

Re: vbar: sum inside bar, rotated and diffent color

Eva — Mon, 07 Jan 2013 10:02:39 GMT

Dear Anca,

I read the annotate book now "Annotate simply the basics" and indeed - annotate is quite easy. Thanx for your code. It works 🙂

Best wishes

Eva