topic Re: horizontal bar chart using sgplot in Graphics Programming

horizontal bar chart using sgplot

Anita_n — Tue, 20 Feb 2018 14:08:24 GMT

I plotted a horizontal Barchart using sgplot. All works fine, the only problem I have, is that I wish to rotate the whole graph so that the

yaxis which is now on the left hand side, is turned to the right hand side. Also is there anyway to get rid of the vertical line on the yaxis? can anyone help?

Re: horizontal bar chart using sgplot

RW9 — Tue, 20 Feb 2018 14:20:01 GMT

You can set the display on yaxis to none:

http://documentation.sas.com/?docsetId=grstatproc&docsetTarget=n0n6uml63c6h8dn16phbd1arm9g9.htm&docsetVersion=9.4&locale=en

See display.

Then you can setup the y2axis as you want to display it:

http://support.sas.com/documentation/cdl/en/grstatproc/65235/HTML/default/viewer.htm#n04drrb1aehuqzn1t12j3958krtw.htm

You will find this blog helpful as it has thousands of examples of all types of graphs:

http://blogs.sas.com/content/graphicallyspeaking/

Re: horizontal bar chart using sgplot

Jay54 — Tue, 20 Feb 2018 14:56:04 GMT

And, if you also want the bars to go from right to left, then you can use the REVERSE option on the XAXIS.

Re: horizontal bar chart using sgplot

Anita_n — Wed, 21 Feb 2018 07:17:13 GMT

Thanks for your quick responses. I tried both methods but haven't still got it working. when I use reverse on the xaxis I get something like this:

How do I get the labels on the left handside? Also I wish to get rid of the line holding the bars. Is there any way to do that?

Re: horizontal bar chart using sgplot

Anita_n — Wed, 21 Feb 2018 11:22:18 GMT

let me just post the sas code here incase someone can help. I will be very gratefull for any help. Thanks

proc sgplot data=sg.test2 noborder nowall;
yaxis grid type=discrete discreteorder=data; 
hbar types /response=total barwidth=0.5 missing datalabel fillattrs=(color=gray);
yaxis display=(nolabel noline noticks); 
xaxis display=(nolabel noline novalues noticks) max=3000 reverse;
run;

and here is the input data

Re: horizontal bar chart using sgplot

Jay54 — Wed, 21 Feb 2018 13:23:44 GMT

Use Y2AXIS as suggested by RW9 (see bold options in code below). Also, you can remove the baseline by setting BASELINEATTRS=(thickness=0) on the HBAR. I would put the grid on the xaxis.

proc sgplot data=sg.test2 noborder nowall; 
hbar types / response=total barwidth=0.5 y2axis missing datalabel fillattrs=(color=gray)
     baselineattrs=(thickness=0);
y2axis display=(nolabel noline noticks) discreteorder=data; 
xaxis display=(nolabel noline novalues noticks) max=3000 reverse grid;
run;

Re: horizontal bar chart using sgplot

Anita_n — Thu, 22 Feb 2018 15:23:32 GMT

Okay, thanks a lot Sanjay, I will try that and let you know if it worked. my regards

Re: horizontal bar chart using sgplot

Anita_n — Mon, 26 Feb 2018 07:09:33 GMT

Thankyou very much Sanjay. It worked very fine. I have also in included the grid on the xaxis.