topic Re: Proc Sgplot in Graphics Programming

Proc Sgplot

twildone — Fri, 26 Jun 2020 03:50:43 GMT

Hi....I am trying to produce graphs for each year using proc sgplot. I tried to used the By statement but that doesn't seem to work. Any suggestion how it can be done. Also, does proc sgplot allow to plot a line on the second y axis? Thanks.

proc sgplot data=have;
vbarparm category=Geo response=University / discreteoffset=-0.17 barwidth=0.3;
vbarparm category=Geo response=College / discreteoffset=0.17 barwidth=0.3;
yaxis valuesdisplay=(0 to 100 by 10) label="Percentage (%) " labelattrs=(size=13 );
xaxis label="Department"  labelattrs=(size=13)  fitpolicy=rotatethin valuesrotate=vertical;
run;

Re: Proc Sgplot

Jagadishkatam — Fri, 26 Jun 2020 04:11:06 GMT

You need to sort the dataset by proc sort and use the by statement in proc sgplot as below

proc sort data=have;
by year;
run;

proc sgplot data=have;
by year;
vbarparm category=Geo response=University / discreteoffset=-0.17 barwidth=0.3;
vbarparm category=Geo response=College / discreteoffset=0.17 barwidth=0.3;
yaxis valuesdisplay=(0 to 100 by 10) label="Percentage (%) " labelattrs=(size=13 );
xaxis label="Department"  labelattrs=(size=13)  fitpolicy=rotatethin valuesrotate=vertical;
run;

Re: Proc Sgplot

twildone — Fri, 26 Jun 2020 13:54:03 GMT

Hi Jag....Thanks for your response. It works but not too sure why the "BY" is highlighted in red in the code....I was expecting it to be in blue. How do you suppress the Year from the by statement from appearing in the graph as I am using #byval(Year) in a Title statement. Thanks.

Re: Proc Sgplot

Jagadishkatam — Fri, 26 Jun 2020 14:01:25 GMT

Using the NOBYLINE system option will cause the BY-line to not be printed.

try using below option and run the graph.

options nobyline;

Re: Proc Sgplot

twildone — Fri, 26 Jun 2020 14:17:29 GMT

Hi Jag....that worked perfectly.....one more thing...can the second y axis be used as a line on the graph which will show to the overall percentage. I am trying to compare the departments with bars and would like to have a line to show the overall percentage if that is possible. Thanks.