Date:         Tue, 25 Mar 2008 10:48:49 -0700
Reply-To:     "Pardee, Roy" <pardee.r@GHC.ORG>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Pardee, Roy" <pardee.r@GHC.ORG>
Subject:      Re: Colon modifer doesn't work for where statement?
Comments: To: Ya Huang <ya.huang@AMYLIN.COM>
In-Reply-To:  A<200803251644.m2PAmA1Q019936@malibu.cc.uga.edu>
Content-Type: text/plain; charset="us-ascii"

Still busted in 9.1.3.

I believe the WHEREs get handed off to the same engine that handles PROC
SQL--you can't use that wildcard in SQL either, I don't think...

-Roy

-----Original Message-----
From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of Ya
Huang
Sent: Tuesday, March 25, 2008 9:45 AM
To: SAS-L@LISTSERV.UGA.EDU
Subject: Colon modifer doesn't work for where statement?

Just noticed I can't use colon modifier with "where", but I can use it
with "if". This is for v8.2. Is this a bug fixed in v9, or it is still
the case in v9?


data xx;
abc=2; acv=3; amk=9; output;
abc=1; acv=3; amk=9; output;
run;

data yy;
* set xx (where=(max(abc,acv,amk)=9)); /* this works */
set xx (where=(max(of a:)=9));        /* this does not */
if min(of a:)=1;                       /* this works */
run;

Ya