MAX function by variable

[deleted_user]

I am looking to use the MAX function, but I want it to find the MAX by different variable groupings. How do I do this?

[deleted_user]

You can try something like this:

PROC SUMMARY DATA=my_data NWAY;
CLASS by_var1 byvar2;
OUTPUT OUT=my_output MAX(var1 var2 var3)=var1 var2 var3;
RUN;

(there is also the option maxid to preserve some id variable (eg: names, data, time, etc...))

Best regards
Jaroslav Message was edited by: Jaroslav