topic Re: Varying x-axis tick marks in sgplot in Graphics Programming

Varying x-axis tick marks in sgplot

sasgorilla — Mon, 28 Apr 2025 22:35:25 GMT

Hi. Is there a way to add a quarterly tickmark without label in between my labeled tick marks?

In other words, I would want to see a tick mark in March and October for each year without a label.

Current code used below. I've tricked tinkering with adding minor and minorinterval options but it hasn't produced the change I want.

Xaxis label="Monthly time series data" values=("01JAN19"d to "30SEP23"d by quarter) labelattrs=(family=arial size=11 weight=bold) Valueattrs=(family=arial size=10) valuesformat=monyy.;

Re: Varying x-axis tick marks in sgplot

sasgorilla — Mon, 28 Apr 2025 22:57:41 GMT

I should also say I'm not exactly sure why it's displaying the monyy and tick mark every 6 months even though I have "by quarter" in the values statement. That is fine, but if someone could help explain why I'd appreciate it.

Re: Varying x-axis tick marks in sgplot

Ksharp — Tue, 29 Apr 2025 01:31:19 GMT

I think that is due to you have too many values/month to plot in X axis.

proc sgplot data=sashelp.stocks;
where year(date) in ( 2001 2002 2003 2004);
series x=date y=close/group=stock;
Xaxis label="Monthly time series data" values=("01JAN2001"d to "01Jan2004"d by quarter)
 type=discrete fitpolicy=rotate ;
run;

Re: Varying x-axis tick marks in sgplot

DanH_sas — Tue, 29 Apr 2025 01:43:41 GMT

On your XAXIS statement, set these two options:

MINOR MINORINTERVAL=quarter

Hope this helps!

Re: Varying x-axis tick marks in sgplot

sasgorilla — Mon, 05 May 2025 23:35:50 GMT

Thanks for this suggestion. I was able to make this work within a test plot. Not sure why it isn't working in my macro though.

Definitely not a pressing issue but if you have any other ideas please let me know. Thanks!

Xaxis label="Monthly time series data" Values=("01MAR19"d to "30SEP23"d by quarter) minor minorinterval=month labelattrs=(family=arial size=11) valueattrs=(family=arial size=10) valuesformat=monyy.;

Re: Varying x-axis tick marks in sgplot

sasgorilla — Mon, 05 May 2025 23:56:00 GMT

This does produce quarterly intervals, but it applies a label to every tick mark (quarterly). Is there a way to get a tick mark without a label at the quarterly intervals?

In other words:

MAR19

tick (for JUN19, no label)

SEP19

tick (for DEC 19, no label)

MAR20

...etc.

Re: Varying x-axis tick marks in sgplot

Ksharp — Tue, 06 May 2025 01:59:25 GMT

An alternative way is using valuesdisplay= option:

proc sgplot data=sashelp.stocks;
where year(date) in ( 2001 2002 );
series x=date y=close/group=stock;
Xaxis label="Monthly time series data" values=("01JAN2001"d to "01jan2002"d by month)
valuesdisplay=('Jan01' ' ' ' ' 'Apr01' ' ' ' ' 'Jul01' ' ' ' ' 'Oct01' ' ' ' ' 'Jan02')
type=linear
;
run;