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;
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!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.