Date:         Tue, 6 Nov 2001 17:33:42 +0100
Reply-To:     "A. L." <franz_cl2003@YAHOO.FR>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "A. L." <franz_cl2003@YAHOO.FR>
Content-Type: text/plain; charset=iso-8859-1

Dear all,

I have a dataset(clinic) which looks like this:


subid     visit      treat

01/001      1          y
01/005      1
01/005      1          n
01/007      2          y
02/001      2          y
02/003      1
02/003      2          y
02/004      1

After a PROC  SORT (BY subid treat)with the option
NODUPKEY I have subid 01/005 and 02/003 twice in the
resulting dataset.
How can I make a test on subid and just keep in such a
case only the observation where treat ne missing.
These mean I do need to have 02/004 in the resulting
datasets because this subid does not appear twice!!!

Thanks so much for your help!
Franz.




___________________________________________________________
Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français !
Yahoo! Courrier : http://courrier.yahoo.fr