Hi, I have this dataset, where Col A could have a repeating value (e.g. 990). I would like the dataset to look like this (select for highest value of '990' so =3) I tried this code that I found on SAS communities (and a few other variations of it): proc means data=sashelp; class record_id ColA; var ColB; output out=want max(ColB)=ColB; run; I ended up getting this output where instead of sas giving me the highest value, I got the average of the values of 990. How do I fix it so that SAS gives me only the highest value for a repeating observation instead of the average? Thanks in advance!
... View more