The SAS Output Delivery System and reporting techniques

Function MAX

Reply
N/A
Posts: 0

Function MAX

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
Super User
Posts: 5,256

Re: Function MAX

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
Data never sleeps
Ask a Question
Discussion stats
  • 1 reply
  • 106 views
  • 0 likes
  • 2 in conversation