How to calculate prevalence for a drug utilization study?

[Emma Tillyer]

Hi! I am conducting a drug utilization study and I want to find how many women aged 50 years and above are prescribed an analgesic by year. Could anyone help me with the code for this?

[Ken Chui]

I'm afraid without knowing the structure of the data it'd be impossible to suggest any code. Please take some time to read the FAQ (https://www.statalist.org/forums/help) and pay attention to section 12 on how to post a question with sample data.