topic Pull one row if the other rows are same in SAS Programming

Pull one row if the other rows are same

user24 — Mon, 10 Oct 2016 19:37:50 GMT

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 — Mon, 10 Oct 2016 20:03:28 GMT

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

then drop the uncessory observations with grade = " "

Astounding — Mon, 10 Oct 2016 20:08:17 GMT

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;