Date:         Tue, 22 Jan 2008 18:56:58 -0800
Reply-To:     gopilth@YAHOO.COM
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         gopilth@YAHOO.COM
Organization: http://groups.google.com
Subject:      Selecting pts with only cancer diagnosis
Comments: To: sas-l@uga.edu
Content-Type: text/plain; charset=ISO-8859-1

Hi,
Iam trying to clean data for some analysis and want to select only the
patients who have HIV only and no other infectious disease based on
the diagnosis code.In other words I want pts with diagnosis code
120,120.1,120.2....120.9(all these codes are for hiv) and exclude
every person with a different diagnosis code as well as if they have
any other diagnosis code along with HIV diag code. The data set I have
is something like this.

pt  diacod
11 200
11 120
11 120.2
20 220
20 120.1
20 120.9
31 120
22 217.9
22 120.8
22 542.9
25 120.6
25 120.9
25 120

Thanks in advance.
Gopi.

.