topic Re: Getting max date value in SAS VA in SAS Visual Analytics

Getting max date value in SAS VA

Rahul_SAS — Wed, 18 Apr 2018 09:24:05 GMT

Dear Experts,

I have two variables ID and Date. I need to get a max date value, tried everything but not able to find a way so please help me.

ID	dates
B0001	01/17/2018
B0002	11/20/2017
B0003	01/16/2018
B0004	11/19/2017
B0005	01/15/2018
B0006	11/18/2017
B0007	01/14/2018
B0008	11/17/2017
B0009	01/13/2018
B0010	11/16/2017

Re: Getting max date value in SAS VA

FredrikE — Wed, 18 Apr 2018 10:56:26 GMT

What do you want to do more specific?
The easiest way is to add a list table and then sort in descending date order and look at the first row 😉

//Fredrik

Re: Getting max date value in SAS VA

Rahul_SAS — Wed, 18 Apr 2018 11:12:32 GMT

Hi Fredrike,

My requirement is to calculate and create a data item which should contain the latest data i.e. 17 Jan 2018 in the given sample data.

That data item will be used in a button bar to highlight Data Refreshed On.

I hope, I am making sense here.

Thanks

Re: Getting max date value in SAS VA

Sam_SAS — Wed, 18 Apr 2018 15:29:50 GMT

Hello Rahul,

Here is a previous discussion about max date in VA:

https://communities.sas.com/t5/SAS-Visual-Analytics/About-getting-the-max-date-in-a-table-field/m-p/204634/highlight/true#M1904

If you just want to display the max date in your report, you can use a rank to select the "top 1" date.

If you need to perform any calculations using the max date, you will need to create a column in your data query using the MAX() function.

Also in 8.2 or 7.4, you can display the timestamp of the most recent update to the data source in a Text object. (Search the doc for "Dynamic Text") But this is not necessarily the same thing as the max date in your data and I believe you cannot do any calculations with this value.

Let us know if this helps.

Thanks,

Sam

Re: Getting max date value in SAS VA

FredrikE — Wed, 18 Apr 2018 15:24:53 GMT

Oki!

Create a new calculated item, use your date variabel and "treatAs" number. Set aggregation to max.

Add a button bar and set your date variabel as category, then rank and pick the highest 1 from your calculated variable.

This will make your button bar show only the highest date in your data.

//Fredrik

Re: Getting max date value in SAS VA

Rahul_SAS — Wed, 18 Apr 2018 17:23:13 GMT

hi Fredrik,

please guide me how to set a date variable to category variable.

thnx

Re: Getting max date value in SAS VA

Sam_SAS — Wed, 18 Apr 2018 17:56:19 GMT

Hi Rahul,

You can assign your date variable to the Category role of the button bar. It is not necessary to convert it to a category data type.

Sam

Re: Getting max date value in SAS VA

FredrikE — Thu, 19 Apr 2018 12:22:52 GMT

As @Sam_SAS says assign it as category role of the button bar, I translated my swedish to english, my bad 🙂

//Fredrik