Hi!
I have a very simple information map containing 4 tables, relations are defined.
How do I create a filter for one of my tables, based on HAVING where clause? What I want is a query that only returns the rows with highest number for my column, example "having my_key_sk EQ max(my_key_sk)"
Thanks for any help pointing me in the right directions,
Regards,
Claes Wedberg
Aggregate filters can be a performance killer, so I would suggest create a new table using this having clause.
If that's not appropriate:
If you are not able to create it in the UI, you could probably create a view on top of the table, and use that instead.
Aggregate filters can be a performance killer, so I would suggest create a new table using this having clause.
If that's not appropriate:
If you are not able to create it in the UI, you could probably create a view on top of the table, and use that instead.
Hi Linus!
Shure thing, I created a view and it works great!
Thanks a lot,
Best regards
/Claes
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.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.