Hi everyone

I have the variables "year" (2009-2019) for each "company key" (e.g.: 1661) and two count variables (the other two columns) and want to drop all observations of a "company key" if every "year" per "company key" has no number.
If a "company key" has a number in one "year", I want to keep every observations of the "company key".

As you can see in the picture:
1661 has no count and needs to be dropped.
1690 has a count in 2010 and every observation should be kept.

Thank you for your help!

Best,
Jana