@Reggiete I'm not sure if I understood your req as I am wondering what is the big deal in proc sql. Please let me know if i'm missing something: data have; input A : $10. Date :mmddyy10. Status $; /*assuming the date is mmddyy10.*/ format date mmddyy10.; datalines; Example 1/1/2017 Open Example 1/3/2017 Pending Example 1/4/2017 Completed ; proc sql; create table want as select * from have group by a having date=max(date); quit;
... View more