https://communities.sas.com/t5/SAS-Enterprise-Guide/MAX-function-by-variable/m-p/38472#M4667 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? Tue, 12 Aug 2008 18:07:49 GMT deleted_user 2008-08-12T18:07:49Z https://communities.sas.com/t5/SAS-Enterprise-Guide/MAX-function-by-variable/m-p/38472#M4667 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? Tue, 12 Aug 2008 18:07:49 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/MAX-function-by-variable/m-p/38472#M4667 deleted_user 2008-08-12T18:07:49Z https://communities.sas.com/t5/SAS-Enterprise-Guide/MAX-function-by-variable/m-p/38473#M4668 You can try something like this:<BR /> <BR /> PROC SUMMARY DATA=my_data NWAY;<BR /> CLASS by_var1 byvar2;<BR /> OUTPUT OUT=my_output MAX(var1 var2 var3)=var1 var2 var3;<BR /> RUN;<BR /> <BR /> (there is also the option maxid to preserve some id variable (eg: names, data, time, etc...))<BR /> <BR /> Best regards<BR /> Jaroslav Message was edited by: Jaroslav Wed, 13 Aug 2008 06:54:11 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/MAX-function-by-variable/m-p/38473#M4668 deleted_user 2008-08-13T06:54:11Z