Hi all SAS experts! My dataset looks something like this: Unique ID Bacteria date: 110 1 s.aureus 1/12 2000 111 1 e.coli 1/12 2000 112 1 e.coli 1/9 2000 113 1 strep 3/10 2004 114 2 s.aureus 1/3 2010 115 2 e.coli 5/3 2010 116 2 pseudomonas 7/3 2010 170 3 pseudomonas 5/10 2005 175 3 e.coli 5/10 2005 176 3 enterobac 5/10 2005 180 3 s.aureus 1/10 2006 190 3 s.aureus 6/12 2006 How can I make SAS to select the first observation from the same ID of the same date only? With this example I would like to for an example keep for ID=1 the unique variable 110 and 111 as they are from the same date but get rid of the other samples with the same ID=1. Hope you guys can help! Kind regards GK
... View more