Date:         Thu, 11 Feb 2010 12:14:40 -0800
Reply-To:     mlhoward@avalon.net
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Mary <mlhoward@AVALON.NET>
Subject:      Re: Is there a better way to do this?
Comments: To: montura <monturainc@GMAIL.COM>
Content-Type: text/plain; charset="UTF-8"

No, one of the questioner's requirements was to have records for those who don't have any of the diagnosis in question; this does not do that, and also is not very expandable for hundreds of possible codes, as there often are in icd 9 codes, as Mike's solutions allow for.

-Mary

--- monturainc@GMAIL.COM wrote:

From: montura <monturainc@GMAIL.COM>
To: SAS-L@LISTSERV.UGA.EDU
Subject:      Re: Is there a better way to do this?
Date:         Thu, 11 Feb 2010 07:02:17 -0800

Simple SQL?

proc sql;
   create table audit as
   select distinct id,
             1 as exclusion
   from have
  where icd9 in(49300,49301,49302);
quit;