ageibe

Discussions

How to look at multiple strings in one column
Hi, created a Case like below: case when `All File Dates` >= `EncounterDate` then 'Probable' else 'Obtain Op Note' end This doesn't work to full capacity because the dates in the "All File Dates" column are in no real order. See below highlighted row. The output for Op note on file should say 'Probable' because the…
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,…

How to look at multiple strings in one column
Hi, created a Case like below: case when `All File Dates` >= `EncounterDate` then 'Probable' else 'Obtain Op Note' end This doesn't work to full capacity because the dates in the "All File Dates" column are in no real order. See below highlighted row. The output for Op note on file should say 'Probable' because the…
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,…