topic Re: clustered bargraph and tickmarks in New SAS User

clustered bargraph and tickmarks

sasuerrr — Wed, 26 Sep 2018 04:20:09 GMT

In the below image for clustered bar graph, I want to align the tickmarks between the two clustered bars. For some of them I see aligned and for others tickmark are not aligned between the bars. I am using SAS 9.4 sgplot. Are there any options that would make this alignment.

Thank you!

Re: clustered bargraph and tickmarks

pink_poodle — Wed, 26 Sep 2018 14:38:14 GMT

You would need to provide the exact values for the x-axis tickmarks in the VALUES= option of the XAXIS statement [1, 2].

It is possible to control the spacing of the tick marks on the time axis. The following statement uses the XAXIS statement to tell PROC SGPLOT to mark the axis at the start of each quarter:
xaxis values=('1jan90'd to '1jul91'd by qtr);
[2]

References

[1] PROC SGPLOT: XAXIS, X2AXIS, YAXIS, Y2AXIS Statements

[2] Using PROC SGPLOT: Working with Time Series Data

Re: clustered bargraph and tickmarks

ballardw — Wed, 26 Sep 2018 21:42:54 GMT

At least provide the code you are using now and some example data.

Also does your data always have exactly 2 bars in each "cluster"? If not then this may be a meaningless task. Depending on your data you may also appear to have "missing" bars if the value for the height is 0.

Example of "missing bar".

data example;
   input xvar groupvar responsevar;
datalines;
1  1  3
1  2  4
2  1  6
2  2  0
2  3  2
;
run;

proc sgplot data=example;
   vbar xvar/group=groupvar response= responsevar
             groupdisplay=cluster
   ;
run;

Re: clustered bargraph and tickmarks

sasuerrr — Thu, 27 Sep 2018 02:56:33 GMT

Below is the code.

proc template;
define statgraph vbarplot;
dynamic _ticklist_;
begingraph / collation=binary;
entrytitle '';
layout overlay / xaxisopts=(type=Discrete discreteOpts=(tickValueList=_ticklist_ tickValueListPolicy=Union tickvaluefitpolicy=rotate) )
yaxisopts=(labelFitPolicy=Split label = "Count" ) cycleattrs=true;
barchart X=chgcatn Y=respvar / primary=true Group=grpname NAME="VBAR" groupdisplay=cluster ;
discretelegend "VBAR"/ location=outside halign=center valign=bottom title=" ";
endlayout;
endgraph;
end;
run;