https://communities.sas.com/t5/SAS-Health-and-Life-Sciences/grouping-patient-diagnoses/m-p/13261#M892 I need to figure out the earliest diagnosis that a patient has given that each patient has many encounters and 10 diagnosis codes for each encounter. The catch is that we only want to look at certain diagnosis codes. Does anyone have any ideas? I already sorted by PatientID and encdate. Just looking at diag1 isn't too difficult. It's after that things get sticky <span class="lia-unicode-emoji" title=":neutral_face:">😐</span> Thu, 29 Apr 2010 22:12:08 GMT marilyn934 2010-04-29T22:12:08Z https://communities.sas.com/t5/SAS-Health-and-Life-Sciences/grouping-patient-diagnoses/m-p/13261#M892 I need to figure out the earliest diagnosis that a patient has given that each patient has many encounters and 10 diagnosis codes for each encounter. The catch is that we only want to look at certain diagnosis codes. Does anyone have any ideas? I already sorted by PatientID and encdate. Just looking at diag1 isn't too difficult. It's after that things get sticky <span class="lia-unicode-emoji" title=":neutral_face:">😐</span> Thu, 29 Apr 2010 22:12:08 GMT https://communities.sas.com/t5/SAS-Health-and-Life-Sciences/grouping-patient-diagnoses/m-p/13261#M892 marilyn934 2010-04-29T22:12:08Z https://communities.sas.com/t5/SAS-Health-and-Life-Sciences/grouping-patient-diagnoses/m-p/13262#M893 Probably the easiest way to do this is to TRANSPOSE the data to get one record per diagnosis and then subset on the diagnoses of interest. Fri, 30 Apr 2010 00:46:06 GMT https://communities.sas.com/t5/SAS-Health-and-Life-Sciences/grouping-patient-diagnoses/m-p/13262#M893 Doc_Duke 2010-04-30T00:46:06Z