Hi All, I do not know how to use MAX IF function in SAS EG so that I can get the following output. Given the left two columns, how can I get the output table (table only, not report) like below? Prefer using EG Query Builder, if cannot, code is also good for me. Thank you so much! School Score Max Score of the School Min Score of the School IT 98 98 70 Biz 80 99 80 Biz 88 99 80 Law 97 97 84 IT 70 98 70 Law 84 97 84 IT 78 98 70 Biz 99 99 80 Law 86 97 84
... View more