How to find lowest date within set of days for each group
Hi, I am trying to find a way to make splitting my data by which visit it is is easier. I have data in the following format (this is of course, fake data): NameDateDiagnosisProviderBob1/1/18RashDr. SallyBob1/1/18flat footDr. JaneBob7/1/18PsoriasisDr. SallyMary1/1/18sprained ankleDr. JaneLouis8/1/18RashDr. Sally I want to create a new column which has the "encounter number" for each one. So f...