I am looking for a way to remove any 0s in a character string. I've found many threads about removing *leading* zeros, but not about removing 0s in general. For example:   Data I have: AB001234 C01403 D00003456   Data I want: AB1234 C143 D3456   Any ideas? Thank you in advance!   ... View more

Hello,  I am working with pharmaceutical prescription records and I am trying to create an output that includes only the most recent prescription for each drug for each person. For example:   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   I want the resulting table to look like this:   John smith     adderall     12/28/17 John smith     oxycodone 11/14/17 jane doe        adderall       2/14/18 jane doe        oxycodone  1/10/18   Right now I am using the code:    proc sort data = master ; by Recipient_Last_Name Recipient_First_Name Date_Dispensed_n descending Drug_Name ; run ; proc sql ; create table final as select * from blaine.master group by Recipient_Last_Name having Date_Dispensed_n = max(Date_Dispensed_n) ; quit ;   This gives me the most recent date for each last name, but I need the most recent date for EACH DRUG associated with a person.  I.e. the code above gives me this:   John smith     adderall     12/28/17 jane doe        adderall       2/14/18   (need to somehow get the most recent prescriptions of other drugs in there)   any help would be appreciated! ... View more