Visual Analytics never officially supported the ability for report viewers to swap out data variables on the fly. So, the workaround from 7.4 and earlier does not work in 7.5x. Beginning in Visual Analytics 8.4, report viewers can swap out a different data item as long as the Viewer Customization level on the report is Data edits.
... View more
Hello,
proc sql;
SELECT *, intnx("year",today(),-1,"s") AS oneYearAgo format=date9., abs(intck("day",dt,intnx("year",today(),-1,"s"))) AS distance
FROM HAVE
HAVING distance=min(distance)
;
quit;
... View more
