With the help of tech support we finally got it working. The key is to create a NUMERIC variable 1 thru 82, then create and apply a user-defined format that re-codes 1 to 'Aug 1- Aug 6', etc. Then put that format library in a place where the server can see it, in my case Lev1\SASApp\SASEnvirnment\SASFormats.  I was lazy and named the catalog "formats" since that's what the SAS Config file was already looking for.    When this numeric variable is brought into VA it is automatically treated as a Category and sorted on by the formatted value.  ... View more

Hi, you have a few options depending on what you want. You could say: %let year=2018; %let prev=%eval(&year-2); title "Original &prev Average Allowed Amount" and "Projected &year Allowed Amount";   Then just change the first statement as needed.   Or if you know it is one year in the future and one year in the past. %let next=%eval(%substr(&sysdate9, 6, 4)+1); %let prev=%eval(&next-2); title "Original &prev Average Allowed Amount" and "Projected &next Allowed Amount";   ... View more