Hi, I am trying to find out a discrepancy in the data. I am expecting to see either Test2 or Test2A has to report 'Yes' for a unique subject but not both. If both (Test2 and Test2A) reported as 'Yes' then I want to provide Discreapancy as 'Yes'. Here is the data what I have: SUBJECT TEST YN 1 Test1 Yes 1 Test2 Yes 1 Test2A Yes 1 Test3 Yes 2 Test1 Yes 2 Test2 Yes 2 Test2A No 2 Test3 Yes 2 Test4 Yes 3 Test1 Yes 3 Test2 Yes 3 Test2A Yes 3 Test3 Yes I would like to see the output like below: SUBJECT TEST YN Discrepancy 1 Test1 Yes 1 Test2 Yes Yes 1 Test2A Yes Yes 1 Test3 Yes 2 Test1 Yes 2 Test2 Yes 2 Test2A No 2 Test3 Yes 2 Test4 Yes 3 Test1 Yes 3 Test2 Yes Yes 3 Test2A Yes Yes 3 Test3 Yes I am new to SAS programming, can you please provide any suggestions how to get the output? Thanks in advance! Pakala
... View more