BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
PaulTHR
Fluorite | Level 6

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

PaulTHR_0-1622210955886.png

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

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
JustinCase
Fluorite | Level 6
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))

View solution in original post

2 REPLIES 2
JustinCase
Fluorite | Level 6
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
Fluorite | Level 6
Thanks very much - that worked

sas-innovate-2024.png

Don't miss out on SAS Innovate - Register now for the FREE Livestream!

Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.

 

Register now!

Tips for filtering data sources in SAS Visual Analytics

See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 2 replies
  • 880 views
  • 4 likes
  • 2 in conversation