Hello, I have a patient dataset with observations across many years. I would like to flag all the observations on the first visit date. If there are multiple diagnoses on the first visit date I would like to also flag those but only if the diagnoses are different. I would like to create a second flag for those with multiple different diagnoses on the first date. See below for an example. FID Date diagnosis flag (want) Multi (want) 1 2016-05-05 anxiety 1 0 1 2016-05-05 anxiety 0 0 1 2016-07-13 ADHD 0 0 1 2016-07-18 Conduct 0 0 2 2017-05-29 conduct 1 0 3 2017-08-16 anxiety 1 0 3 2017-10-18 adhd 0 0 4 2017-11-16 conduct 1 1 4 2017-11-16 adhd 1 0 4 2017-12-10 anxiety 0 0
... View more