How to get last date
Hi, I am new here! I have a dataset that has data on multiple rows for the same patient with different encounter dates. I want to only see the unique patient once (so patient ID is the identifier) and show me only the most recent encounter date. Example data: John Doe, Patient ID 1, encounter date 1/3/2022 John Doe,…