| Date: | Mon, 21 Jul 2008 02:34:36 -0700 |
| Reply-To: | HXDAIC <HXDAIC@GMAIL.COM> |
| Sender: | "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU> |
| From: | HXDAIC <HXDAIC@GMAIL.COM> |
| Organization: | http://groups.google.com |
| Subject: | Re: How to pick right records |
|
| Content-Type: | text/plain; charset=ISO-8859-1 |
Proc sql;
create table noapproval as
select * from test
where Person not in (select person from test where Judgement EQ
'approved');
quit;
|