Hi Stata Friends -

I'm back with a question regarding creating a table of values. I want to ascertain how many individuals presented with a particular condition over the 7 years of records. In the data, there are multiple records per patient, and multiple patients per year.

I've successfully executed a simple table command
Code:
 table Asthma Year
OR
Code:
 total Asthma, over(year)
Either of which provide me with a count of how many times that condition presents per year. Good. The problem is that since there are multiple records per patient, the figures in that table are 'inflated' as they're returning the indicator more than once per patient.

Is there a way by which I can create a table that is still formatted as indicator variable grouped by year but only counts one instance of the indicator per patient? It is not feasible to use patient as the grouping variable (instead of year) as there are over 400K unique patients.

Thank you!

**I apologize for not being able to provide examples or data snippets, I am working on a secure server that expertly sequesters STATA from the internet and clipboard.