Date:         Thu, 21 Aug 2008 10:28:23 -0700
Reply-To:     Akshaya <akshaya.nathilvar@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Akshaya <akshaya.nathilvar@GMAIL.COM>
Organization: http://groups.google.com
Subject:      Re: Is CASE-WHEN logic available in the WHERE statement in PROC
              SQL
Comments: To: sas-l@uga.edu
Content-Type: text/plain; charset=ISO-8859-1

Hi Jack,

Case expressions can be used to create, modify columns, update
existing rows or to insert new rows. It can't be used in WHERE clause.
Instead correlated or non-correlated subqueries can be used in WHERE
clause to perform the join. Hope this helps.

Regards!
Akshaya