Here's the program *generated* by EG with my point and click approach (includes your sample data).
[pre]
data claims;
length claim $ 1 LossYr 3 ReptYr 3 Amount 8;
input claim LossYr ReptYr Amount;
datalines;
A 6 6 10000
A 6 7 20000
B 7 7 10000
B 7 8 5000
C 7 7 10000
C 7 8 10000
E 8 8 20000
F 7 7 5000
F 7 8 5000
G 7 7 5000
H 6 6 10000
H 6 7 5000
;
/* generated by Rank Data task */
PROC SORT
DATA=WORK.CLAIMS
OUT=WORK.SORTTempTableSorted
;
BY claim;
RUN;
PROC RANK DATA = WORK.SORTTempTableSorted
DESCENDING
TIES=MEAN
OUT=WORK.RANKEDCLAIMS;
BY claim;
VAR ReptYr;
RANKS rank_ReptYr ;
/* generated by Query Builder */
PROC SQL;
CREATE TABLE WORK.RecentClaims AS
SELECT t1.claim,
t1.LossYr,
t1.ReptYr,
t1.Amount
FROM WORK.RANKEDCLAIMS AS t1
WHERE t1.rank_ReptYr = 1;
QUIT;
[/pre]