SAS Visual Analytics V. 8.5 I have a dataset that appends a new monthly snapshot to previous months on the fourth of every month. I am looking at comparing values for a given month with previous years. I converted the date of snapshot variable to months format (numeric 1 - 12) and placed on a line graph grouping by year. For a given month this provides me with my year-over-year comparison. However, I am just looking for the past six months. Current month (March) would roll to previous year. I'm wondering how I would sort months to be in order but roll to the next year. Proper sort would be as follows: (Oct., Nov., Dec., Jan., Feb., Mar.) I looked at custom sorts, but the sorting would change depending on the given month and it isn't as simple as sorting in reverse order by month. The month variable is a date category formatted by month (so numeric values 1 - 12.) Any advice on how to automate sorting to be rolling six months is much appreciated!
... View more