BookmarkSubscribeRSS Feed
Allan_dk
Quartz | Level 8

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.

 

 

 

 

2 REPLIES 2
Sam_SAS
SAS Employee

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

MichelleHomes
Meteorite | Level 14

I wonder if you use the TreatAsNumber function on the date whether the First and Last functions would work... something to try...

 

Cheers,

Michelle

//Contact me to learn how Metacoda software can help keep your SAS platform secure - https://www.metacoda.com

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
  • 1023 views
  • 0 likes
  • 3 in conversation