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.
... View more
