Date:         Tue, 22 Nov 2011 15:43:09 -0500
Reply-To:     sas quest <sasquest@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         sas quest <sasquest@GMAIL.COM>
Subject:      Flagging at visit
Content-Type: text/plain; charset=ISO-8859-1

Hi,

I have a dataset like this

data have;
input pt visit test $ status $8.;
cards;
100 1 A Not Done
100 1 B Not Done
100 1 C Done
100 1 D
100 2 A Not Done
100 2 B Done
101 1 A Not Done
101 1 B Not Done
101 1 C Not Done
102 1 A
102 1 B Done
102 1 C Not Done
103 1 A Not Done
103 1 B Not Done
104 1 A
104 1 B Done
105 2 A Not Done
106 1 A
;
run;

I need to identify pt=101, 103 and 105 where Status='Not Done' within a
vist .    For some reason Proc SQL cannot be used.

Want:
101 1 Not Done
103 1 Not Done
105 2 Not Done

Thanks in advance.