Hi I want to select observations based on the initial visit or the date of diagnosis. Patient ID Date of Visit Diagnosis code 1 Diagnosis Code 2 A 0 0881 0981 A 2 0981 0234 A 5 0234 0567 A 30 0881 . B 0 0881 0781 B 3 0881 . B 9 0789 0456 B 45 0781 . In the above table Day 0 is the initial visit or date of dignosis for two patients A and B. A got the diagnosis codes 0881 and 0981 on initial visit. I want to select all subsequent visists of A when he had either of those codes (i.e. Day 2 and 30 selected but not day 5) . Similiarly B had diagnosis codes 0881 and 0781 on the day of diagnosis, I want to select subsequent visits where either of theses codes appear (days 3 and 45 but not 9). Is there a programing short cut or procedure to check a unique criteria for each patient in a dataset? i.e. create a crietia for patient A and B and teh check it against subsquenet visits?? Thanks Manjunath
... View more