Pull one row if the other rows are same

[user24]

I have a table as below:

id     grade  course

15      A        class1

15                class1

17     B         class1

17     A         class2

20                class2

20      C        class2

21                 class1

I need to pull only one row with grade if the id and course same. I mean as below:

id    grade  course

15    A         class1

17    B         class1

17    A        class2

20    C       class2

21               class1

Thank you

[Di_Pat]

Sort your table by id and course and use nodupkey option. 

then drop the uncessory observations with grade = " " 

[Astounding]

You could try it this way:

proc sort data=have;

by id course grade;

run;

data want;

set have;

by id course;

if last.course;

run;