Hi, I'm running SAS 9.4 on Windows.  I'm receiving this notification message when I run the following code.   NOTE: Time axis can only support date time values. The axis type will be changed to LINEAR.   data aaa; set bbb; format date year4.; pct_diff = (f_&var/f_&var._2017-1)*100; run;   proc sgplot data=aaa noautolegend; title "Percent Difference: 2018/2017"; band y=pct_diff lower="01oct2017"d upper="30sep2044"d / fillattrs=(color=blue transparency=0.95); series x=date y=pct_diff / lineattrs=(color=blue thickness=2); xaxis grid values=("01jan2012"d to "01Jan2020"d by year) display=(nolabel); yaxis grid label="Percent"; run;   The graph is drawn properly since, I think, my data is evenly spaced so linear has no impact.  But it would still be nice to clean up my log file and also to understand what is causing this.   Can anyone help?  Thanks in advance, Jonathan   ... View more

Hi, Time series data (CPI, for example) are often indexed to a specific base year such that the value in that year is 1 (or 100) and the values in other years are expressed as ratios to the base year value.  I would like to re-base (or re-index) my series to a new base year which simply involves dividing each value by the value in my desired base year.  The difficulty is that for the early years, I need to know the value in that later, base year.  Does anyone know if there's a simple way to do this (i.e. without getting in to macro programming)?   Thank you all!   ... View more