topic Re: Displaying all Labels for X-Axis in Graphics Programming

Displaying all Labels for X-Axis

Pritish — Fri, 03 Apr 2020 02:28:53 GMT

Hi All - I am trying to plot year-quarter values on the x axis using sgplot and have around 50 labels. When I use SGPlot, it only shows every alternative year quarter instead of all the 50 labels. Is there any way, I can show all possible value on the x-axis? I did explore 'values' options, but it might not a good option as the year-quarter information will vary based on my data.

Any thoughts / guidance will be appreciate.

Re: Displaying all Labels for X-Axis

DanH_sas — Fri, 03 Apr 2020 02:46:58 GMT

What do you get when you specify INTERVAL=QUARTER on your XAXIS statement?

Re: Displaying all Labels for X-Axis

Pritish — Fri, 03 Apr 2020 03:07:04 GMT

I tried Interval = quarter option, however it does not show all the possible values. It skips every 2/3 quarters.

Re: Displaying all Labels for X-Axis

ballardw — Fri, 03 Apr 2020 14:30:46 GMT

Please show the entire code you are using.

Also it may help to tell us the format currently assigned to the x-axis variable.

Are you getting any notes in the log about fitting values to your axis space?

Re: Displaying all Labels for X-Axis

Pritish — Mon, 06 Apr 2020 13:59:08 GMT

Below is the code which I am using:
/* x axis column date_mmddyyyy has the format mmddyy10. : for ex: 03/31/2009 */

proc sgplot data=graph;
XAXIS Label="YYYYQ" valuesformat=yyq6.
interval=quarter valuesrotate=vertical fitpolicy=rotate;
band x=date_mmddyyyy lower=0 upper= _freq_ / y2axis name="v3";
series x=date_mmddyyyy y=mean;
series x=date_mmddyyyy y=median;
run;
Below is the note, I get when I execute the program.
NOTE: TICKVALUEFITPOLICY=Rotate is ignored when SPLITTICKVALUE=TRUE. The default THIN policy is used.
NOTE: Some of the tick values have been thinned.
NOTE: TICKVALUEFITPOLICY=Rotate is ignored when SPLITTICKVALUE=TRUE. The default THIN policy is used.
NOTE: Some of the tick values have been thinned.

Re: Displaying all Labels for X-Axis

Tom — Mon, 06 Apr 2020 15:23:10 GMT

Smaller font? Larger plot? Rotate the axis labels?

Re: Displaying all Labels for X-Axis

Pritish — Mon, 06 Apr 2020 16:08:25 GMT

I have not tried reducing the font size. I will give it a try and see if it works.

Re: Displaying all Labels for X-Axis

Rick_SAS — Mon, 06 Apr 2020 17:04:18 GMT

For date axes, PROC SGPLOT will perform special processing to handle the fact that months are different lengths. The NOTE is telling you that the special processing is occurring. For example, see the results of each of these calls:

proc sgplot data=sashelp.stocks;
series x=date y=open / group=stock;
run;

proc sgplot data=sashelp.stocks;
where date < '01jan1990'd;
series x=date y=open / group=stock;
run;

Re: Displaying all Labels for X-Axis

Barkat — Wed, 01 Dec 2021 00:51:55 GMT

Try the following

xaxis values=(a to b by 1);

a means the start value

b means the end value