Quickness and accuracy are competing ends of the programming continuum. I suggest that most code lies somewhere in the middle.

I wish I could go to SUGI and see all you guys. Alas, I'll wait until it's here in CA.

Paul Choate DDS Data Extraction (916) 654-2160

-----Original Message----- From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of toby dunn Sent: Tuesday, April 05, 2005 8:04 AM To: SAS-L@LISTSERV.UGA.EDU Subject: Re: awkward code

Ian ,

I did say it was untested... but your right acurate is better than fast which I seem to miss more than I care to admit. Guess I have something to work on...

In any event I was unsure how SQL would treat the statement ID and w not in (select.....). Looks like it treats it differently than I had hoped. It is more like where ID is not missing or '0' and w not in the list from the select statement.

Thanks , Toby Dunn

P.S. I also look forward to meeting you at SUGI and hearing your presentation on Macro Debuging.

From: Ian Whitlock <iw1junk@COMCAST.NET> Reply-To: iw1junk@COMCAST.NET To: SAS-L@LISTSERV.UGA.EDU Subject: Re: awkward code Date: Tue, 5 Apr 2005 14:33:20 +0000 Toby,

You seem to be missing one important ingredient in your programming career. Take a hint from Wyatt Earp, "Fast is fine, but accuracy is everything."

Here is some code to test with

data ret ; do w = 0 to 2 ; do id = 0 to 3 ; output ; end ; end ; run ;

data d1 ; a = 1 ; run ;

proc sql ; select * from ret where ID and w not in (select a from d1) ; quit ;

The code executes without error. Do you know why? Looking forward to seeing you at SUGI. Promise, I won't kick. Ian

Jianping,

Assuming the code does what you want, the only thing that looks awkward to me is the names you have chosen.

Ian Whitlock =================== Date: Tue, 5 Apr 2005 13:39:54 +0000 Reply-To: toby dunn <tobydunn@HOTMAIL.COM> Sender: "SAS(r) Discussion" From: toby dunn <tobydunn@HOTMAIL.COM> Subject: Re: awkward code Comments: To: zhujp98@gmail.com In-Reply-To: <6716d5d05040420533d6aaadc@mail.gmail.com> Content-Type: text/plain; format=flowed Jainping, Not sure if this will work its untested but: proc sql ; select * from ret where ID and w not in (select a from d1) ; quit ;

Toby Dunn

From: Jianping Zhu <zhujp98@GMAIL.COM> Reply-To: Jianping Zhu <zhujp98@gmail.com> To: SAS-L Subject: awkward code Date: Mon, 4 Apr 2005 23:53:48 -0400

proc sql; create table new as select * from ret where id not in ( select a from d1 ) and w not in ( select a from d1 ) ; quit; This code looks awkward, is there a way to simlify it? Thx.