Date: Tue, 21 Sep 2010 09:24:52 -0500
Reply-To: "Data _null_;" <iebupdte@GMAIL.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: "Data _null_;" <iebupdte@GMAIL.COM>
Subject: Re: SAME-AND operator in Data Step
In-Reply-To: <279E0CB25CBDEF4DB4A50E89328780E223B4E9CC@CHEXCMS08.one.ads.che.org>
Content-Type: text/plain; charset=ISO-8859-1
On Tue, Sep 21, 2010 at 9:17 AM, Viel, Kevin <kviel@sjha.org> wrote:
I am not sure how this might be better than:
>
> Where ( PRODUCT in('H','P','Q') or GROUP=:'E' )
> And FLAG_A='Y'
> And FLAG_B='N';
> And INCURRED_DATE between &DATE1 and &DATE2
> ;
It's not better but for a different purpose.
SAME-AND Operator
Use the SAME-AND operator to add more conditions to an existing WHERE
expression later in the program without retyping the original
conditions. This capability is useful with the following:
interactive SAS procedures
full-screen SAS procedures that enable you to type a WHERE expression
on the command line
any kind of RUN-group processing.
Use the SAME-AND operator when you already have a WHERE expression
defined and you want to insert additional conditions.