The SAS Output Delivery System and reporting techniques

Function MAX

Not applicable
Posts: 0

Function MAX


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,

Super User
Posts: 5,888

Re: Function MAX

Posted in reply to deleted_user
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.

Data never sleeps
Ask a Question
Discussion stats
  • 1 reply
  • 2 in conversation