Exploring, predicting and reporting with SAS Visual Analytics and SAS Visual Statistics

Show date alongside Last value

Reply
User
Posts: 1

Show date alongside Last value

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

Regular Contributor
Posts: 191

Re: Show date alongside Last value

Would't it work with last on the date as well?
Ask a Question
Discussion stats
  • 1 reply
  • 151 views
  • 0 likes
  • 2 in conversation