data have;
input studentid Grade$ final_grade $ course $;
cards;
1 . A MATH
1 . A MATH
1 C B ECON
1 B A ENG
1 B A ENG
1 . C SCI
1 F C SCI
1 . B CHEM
2 D B ENG
2 . B ENG
2 . A CHEM
3 F C MATH
;
proc sort data=have out=_have;
by studentid course;
run;
data want;
update _have(obs=0) _have;
by studentid course ;
run;
... View more
