If I understood what you mean. data have; input incidentId year discScore EmpNo; datalines; 1 2005 2 123 2 2006 5 123 3 2007 0.5 123 4 2008 1 123 5 2009 1.5 123 6 2001 2.5 456 7 2002 3.5 456 8 2003 5 456 9 2004 5 456 10 2009 4 789 11 2010 5 789 12 2006 5 1011 ; run; proc sql; create table want as   select distinct empno    from have as a     where discscore=5      having (select count(*) from have where empno=a.empno and year gt a.year) gt 0; quit; Ksharp ... View more