Here's an approach that might be just what you want.
proc sort data=have;
by company year variable;
run;
data want;
set have;
by company year;
if first.year;
run;
It selects just one observation per COMPANY/YEAR, taking a "No" if one exists, and a "Yes" if there aren't any "No" in the data. There's some question in my mind whether this is the result you are looking for, so you will have to comment on that.
... View more
