I have searched everywhere, but I don't seem to find the answer. I think my problem is simple, but I can't get it right. My problem: In a dataset, I have patients having multiple diagnoses and duplicate diagnoses. I need to delete these duplicate diagnoses per patient, meaning another patient having the same diagnose should not be deleted.  Example of dataset (not real data): Patient_ID Diagnose   1 1 Keep observation 1 1 Delete observation 1 2 Keep observation 1 3 Keep observation 2 1 Keep observation 2 1 Delete observation 2 3 Keep observation 2 3 Delete observation 3 1 Keep observation 3 2 Keep observation 3 5 Keep observation 3 6 Keep observation 4 1 Keep observation 4 1 Delete observation 4 3 Keep observation 4 3 Delete observation Thanks in advance! ... View more

Hello.  I have a dataset of patients having multiple hospital visits. Patients are included in my study, when they have a specific diagnose. I need to keep all visits and diagnoses prior to the inclusion date, and deleting all visits after the inclusion date.    Example of dataset (not real data). Inclusion when a patient have diagnose code '200':   Patient_ID visit_ID Date Diagnose   1 1 01.01.20 111 Keep observation 1 2 02.01.20 154 keep observation 1 3 03.01.20 200 keep observation 1 4 04.01.20 085 delete observation 2 5 01.06.20 119 keep observation 2 6 02.06.20 543 keep observation 2 7 03.06.20 200 keep observation 3 8 01.09.19 746 keep observation 3 9 02.09.19 549 keep observation 3 10 03.09.19 200 keep observation 3 11 04.09.19 432 delete observation 3 12 05.09.19 543 delete observation How can this be done? I use SAS 9.4. Thanks! ... View more

Hello.   I need to calculate Wilcoxon Mann-Whitney Odds with 95% CI (WMWodds). I have found a website describing have to do these calculations, but the attached macro is no longer available (see https://support.sas.com/resources/papers/proceedings/proceedings/sugi31/209-31.pdf). Does anyone know, if WMWodds is built into SAS, or where i can download a macro?   I'm using SAS 9.4.   Best regards Joachim ... View more