Show date alongside Last value

[peachyco]

Hi.

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. ^_^

[FredrikE]

Would't it work with last on the date as well?