Is it possible to display aggregated date values in tables?
I have a dateset that contains data about users acces to VA. "Who do what when?"
[user, transaction date, event]
I would like to display information like
user, max_date, min_date
and give the user ability to filter data.
I can't calculate the max and min variables before I load data til LASR server.
That always semes to be the solution with SAS VA.
Hi Allan,
I don't think there is an easy way to do this, although someone might know of a workaround.
It is frustrating that the First and Last operators only accept a measure as input, otherwise I think you could do something like,
First [_ByGroup_] ('Date'n, 'Date'n, _IncludeMissing_)
to get the earliest aggregated date value.
Hope someone else can help you further,
Sam
I wonder if you use the TreatAsNumber function on the date whether the First and Last functions would work... something to try...
Cheers,
Michelle
Registration is now open for SAS Innovate 2025 , our biggest and most exciting global event of the year! Join us in Orlando, FL, May 6-9.
Sign up by Dec. 31 to get the 2024 rate of just $495.
Register now!
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.