Function MAX

[deleted_user]

Hi,

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.

Any ideas are highly welcome!
Best regards,

nana

[LinusH]

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?

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.

/Linus