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
Sort your table by id and course and use nodupkey option.
then drop the uncessory observations with grade = " "
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;
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.