Hi everyone, I have a data with Diagnoses at each year of Medical exam. I am trying to select ALL Diagnosis data (all lines) from the MOST RECENT EXAM ONLY, for each ID. Please, can you help me with the coding, see below the database structure. Thanks in advance, ID Calendar Year Diagnosis 1 2016 TB 1 2016 No health condition 1 2016 No health condition 2 2014 TB 2 2016 Inactive/Latent Tuberculosis 3 2014 TB 3 2016 Inactive/Latent Tuberculosis 3 2016 HIV 3 2016 Hypertension 4 2015 Cancer 4 2014 No health condition 4 2016 TB
... View more