https://communities.sas.com/t5/ODS-and-Base-Reporting/Function-MAX/m-p/65890#M7660 Hi,<BR /> <BR /> I'm new in SAS and I would like in DIS to calcul a MAX of the column. The expression Max(Mois_cession) is not ok because it calcul the max of the cell and not the max of the column.<BR /> <BR /> Any ideas are highly welcome!<BR /> Best regards,<BR /> <BR /> nana Mon, 15 Dec 2008 13:53:29 GMT deleted_user 2008-12-15T13:53:29Z https://communities.sas.com/t5/ODS-and-Base-Reporting/Function-MAX/m-p/65890#M7660 Hi,<BR /> <BR /> I'm new in SAS and I would like in DIS to calcul a MAX of the column. The expression Max(Mois_cession) is not ok because it calcul the max of the cell and not the max of the column.<BR /> <BR /> Any ideas are highly welcome!<BR /> Best regards,<BR /> <BR /> nana Mon, 15 Dec 2008 13:53:29 GMT https://communities.sas.com/t5/ODS-and-Base-Reporting/Function-MAX/m-p/65890#M7660 deleted_user 2008-12-15T13:53:29Z https://communities.sas.com/t5/ODS-and-Base-Reporting/Function-MAX/m-p/65891#M7661 It seems a bit odd to summarize a whole column when building DIS jobs, most common is to summarize on class/group by column(s). What do you want to accomplish?<BR /> <BR /> But you can do it, I assuming that you are using SAS Extract transformation. My guess is that you are selecting additional columns that you don't have a summary function on, which means that SQL will remerge the result on each input row.<BR /> <BR /> /Linus Mon, 15 Dec 2008 14:20:14 GMT https://communities.sas.com/t5/ODS-and-Base-Reporting/Function-MAX/m-p/65891#M7661 LinusH 2008-12-15T14:20:14Z