Dear Experts

I have been trying to analyse COVID-19 related data where each subject submits reports and measurements of vitals. I need to classify patients based on the parameters recorded. Here is an example, dummy data:
ID reporting date heart rate Saturation respiratory rate
1233 15.Jul 98 96 16
1233 17.Jul 80 90 18
1233 20.Jul 75 95 19
1233 25.Jul 78 98 25
I understand the data is in long format. So if I try to define COVID with moderate severity based on a combination of heart rate (>90 at any given day), saturation (<95 at any given day), and respiratory rate (>20 at any given day), the end result is that this patient 1233 is not considered moderately severe because Stata applies the condition on row-basis. Indeed, I tried to reshape the data to wide format, but I ended with thousands of variables because reporting dates vary across subjects, so I could not use it along with the ID.

I would simply need Stata to look, within each ID, for any responses fulfilling the condition, regardless of the date, and without the need to reshape the data. Is this even possible?

I appreciate your help

Omar