Control x-axis label and tick spacing in time series proc sgplot

[seanrez]

I'm having zero success controlling the distance between x-axis ticks/labels. Here's my code, with different things I've tried like type=discrete, interval=week, values=(), etc...

proc sgplot data = work.weather_adjustment_daily;
	vbar del_date / response = Weather_Adjustment;
	vline del_date / response = Temperature y2axis lineattrs = (thickness = 2);
	vline del_date / response = Temp_Norm y2axis lineattrs = (thickness = 2);
	vline del_date / response = Temp_One_Year_Ago y2axis lineattrs = (thickness = 2);
/*	xaxis type = discrete  interval = week */
/*	xaxis values = (%sysfunc(intnx('month', %sysfunc(today()), -2)) to %sysfunc(intnx('month', %sysfunc(today()), 2)) by 7)*/
/*	axis order = ('01Jan2018' to '01Jan2020' by 10);*/
	xaxis label = "Date";
	yaxis label = "Weather Adjustment (MW)";
	y2axis label = "Daily Mean Temperature";
	title "Daily Weather Adjustment and Temperature";
run;

My chart is below, with too many x-axis labels. I'm using SAS v9.3.

[DanH_sas · Accepted solution]

You need to choose a different FITPOLICY on the XAXIS statement. For SAS 9.3, these are the policies supported:

THIN
ROTATE
ROTATETHIN
STAGGER
STAGGERROTATE
STAGGERTHIN

Hope this helps!

Dan