data master; retain name fname lname drug date; input fname $ lname $ drug: $9. date: mmddyy8.; format date mmddyy8.; name=cat(fname,lname,' '); cards; John smith adderall 12/28/17 John smith adderall 12/21/17 John smith oxycodone 11/14/17 jane doe adderall 2/14/18 jane doe oxycodone 1/10/18 jane doe adderall 12/21/17 ; run; proc sort data=master; by name drug descending date; run; data master_result; set master; by name drug descending date; if first.drug then output; run;
... View more
