medication

Hi everyone, I'm new to stata, so any advice on how to code this would be greatly appreciated. I have medication data for 1500 patients. Each row represents a unique medication ID, so each patient may be represented in multiple rows if he/she has multiple meds (example below). I'd like to...