Hello I have a question for you if you can help if it will nice. Here my code in data steps how I can write this code with Proc SQL to get the same thing. I will appreciate it if you could answer. Thank you I would want any summary records. I would like the duplicate removed by the LAST.clm_ln_src_id I tried everything with nested proc SQL or Having, max(clm_ln_src_id). none of them worked. Thank you Warmest regard, Jean-Luc Fanny PROC SORT DATA= Horizon_ClaimsHealth; BY LEGACY_ORIGINAL_CLAIM_ID clm_ln_src_id VOIDSORT SORTCARD ; RUN; DATA Horizon_ClaimsHealth_v2 ; SET Horizon_ClaimsHealth; BY LEGACY_ORIGINAL_CLAIM_ID clm_ln_src_id VOIDSORT SORTCARD ; IF LAST.clm_ln_src_id THEN OUTPUT; RUN;
... View more