Hi Each ID has several instances, and each instance has a different value. I would like the final output to be the maximum value per ID and per year. So the initial dataset is: ID year Value
1 2012 100
1 2013 7
1 2013 65
2 2015 12
2 2015 97
3 2011 82
3 2012 54 3 2012 95 And the output will be : ID year Value
1 2012 100
1 2013 65 2 2015 97
3 2011 82 3 2012 95 I tried running proc means : proc means data=H10 noprint; class ID year ; var value; output out=want max(value)=; run; but it dosen't work. thx u very much.
... View more
