|Date: ||Fri, 15 Nov 2002 04:57:28 +0000|
|Sender: ||"SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>|
|From: ||Paul Dorfman <paul_dorfman@HOTMAIL.COM>|
|Subject: ||Re: where also statement|
|Content-Type: ||text/plain; format=flowed|
There is NO difference. ALSO adds its entire query to all the queries
specified earlier as if there were the AND operator. The compiler first sees
the first query, then sees the second, adds its devinition to thge first and
issues the message.
Also please look at the FSP documentation. I bet you can find it there,
although I agree that NOT having documented the feature in the language
manual is a sin.
Paul M. Dorfman
Original---- Message Follows----
From: Nick Paszty <paszty@XOMA.COM>
Reply-To: Nick Paszty <paszty@XOMA.COM>
Subject: where also statement
Date: Thu, 14 Nov 2002 17:00:06 -0800
solaris 8, SAS 8.2.
i found that a programmer was using a where also statement and when i
asked what the difference was between the following code, the answer
was nothing. i have not been able to find documentation on this and
when i test, i don't see any difference.
where (var1=2 and var3=4);
where also var3=4;
the message to the log is that the where statement has been augmented.
anyone know what the processing difference is and if there is an
advantage of one over the other?
The new MSN 8: advanced junk mail protection and 2 months FREE*