Need help for below scenario I have data set as like below. I want to remove the members those who are in lapsed status from the data set (i.e Where status = 1 in the latest date) . option compress = yes; data sample; input member_id status change_date DDMMYY10.; format change_date date9.; datalines; 123 2 10072013 123 3 18072013 123 1 03082013 456 1 08082013 456 2 17082013 789 3 14052013 ; run; proc print data = sample; run; In the above data set member_id 123 having 3 observations. The third observations 123 1 03082013 is the latest record also having status = 1 . So The member should not come to the report. It needs to be eliminated. The member_id 456 having 2 observations. The second observations 456 2 17082013 is the latest record also having status = 2 . So The member should come to the report. Please help me on this. Thanks, Kannan B.
... View more