DATA Step, Macro, Functions and more

Pull one row if the other rows are same

Reply
Contributor
Posts: 33

Pull one row if the other rows are same

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

Occasional Contributor
Posts: 13

Re: Pull one row if the other rows are same

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

then drop the uncessory observations with grade = " " 

Super User
Posts: 5,498

Re: Pull one row if the other rows are same

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;

Ask a Question
Discussion stats
  • 2 replies
  • 394 views
  • 0 likes
  • 3 in conversation