topic Re: Max(date) in SAS Visual Analytics

Max(date)

PaulTHR — Fri, 28 May 2021 14:11:28 GMT

In Data Plans and in 'New calculated item'

I want to create a new category so I can display on its own the max date of a field (as in the latest submisison date is xx/xx/xxxx

Max [_ForAll_] ('submission_date'n)

I have tried the MAX operator but it states

I wish to make this available in my SAS Viya report but make the changes above in Data Plans.

I do not wish to use SAS code

Any ideas

Thanks

JustinCase — Tue, 15 Jun 2021 08:16:46 GMT

The only way that I can come close to what you want is when I create the max date as a number:
Max [_ForAll_] (TreatAs(_Number_, 'Date'n))

PaulTHR — Thu, 24 Jun 2021 11:40:05 GMT

Thanks very much - that worked