06-06-2017 02:38 AM
In SAS Visual Analytics 7.3, I have a report with a table that shows a list of products. For each product in this list, the table also shows its *last price according to the pricing date*. This is accomplished easily enough with the Last( By Group ) operator.
What I wish to do now is to display the *corresponding pricing date for this last price*, so that my users have an idea of how recent the shown price is. I've tried using Rank but I've only gotten to displaying the date as a number, not in any meaningful format.
If it matters, the dataset used in this report appears like so:
PRODUCT | PRICE_DATE | PRICE_USD Product1 | 2017-01-02 | 21.01 Product1 | 2017-02-05 | 22.52 Product2 | 2017-01-02 | 52.00 Product2 | 2017-01-25 | 51.50 Product3 | 2017-01-15 | 113.72
Any advice would be much appreciated. Thanks. ^_^