How to I only output the instances where the subject has the highest level? (example included)

[Hello_there]

data have1;
infile datalines dsd dlm=",";
	input subj $ treatment $ painlvl bodypart $;
datalines;
001, A, 1, leg
001, A, 2, leg
002, B, 1, head
003, A, 1, arm
004, B, 1, eye
005, B, 2, mouth
; 
run; * choose distinct subjects with highest severity (if more than one instance);

Hello,

information:

* 6 obs

* n=5

* 2 treatment groups (A, B)

Goal: 001 has two reported painful observations in the same area (leg), and the goal is to

output the row where he has the highest pain level, so that my resultant data set will include 5 rows.

Could I receive some help? I tried PROC SQL and using the max() paired w/ the group by clause. It worked but I received an error. 

Thanks

[mkeintz]

Help us help you.  Please show the log including the code and the error message it produced.  

Use the "</>" icon to make a text box for that content.

[Hello_there]

I don't know if it was an error, but it said something to the effect of not liking me using a summary function when trying to group by subject when i was selecting count(distinct subject).

Anyways, i found a data step way to do it which is to sort by subj treatment bodypart desecnding painlvl, and then proc sort again by subj nodupkey.

Thanks anway though

[Ksharp · Accepted solution]

data have1;
infile datalines dsd dlm=",";
	input subj $ treatment $ painlvl bodypart $;
datalines;
001, A, 1, leg
001, A, 2, leg
002, B, 1, head
003, A, 1, arm
004, B, 1, eye
005, B, 2, mouth
; 
run;


proc sql;
create table want as
select * from have1
 group by subj
  having painlvl=max(painlvl);
quit;