Hello community, I'm having a lot of trouble finding the solution to my problem, I hope you can help me
I have a table that was created from a union, example:
ID RECEIVED PAID REFERENCE
0 100 50 1
1 200 60 1
2 300 70 1
3 400 80 2
4 500 90 2
I'd like to create an aggregated measure that takes all RECEIVED values that have reference equal 1, and another measure for equal reference 2. I've tried several ways to get these measures but I did not succeed.
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.