LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous messageNext messagePrevious in topicNext in topicPrevious by same authorNext by same authorPrevious page (November 2002, week 2)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:   Fri, 15 Nov 2002 04:57:28 +0000
Reply-To:   sashole@bellsouth.net
Sender:   "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:   Paul Dorfman <paul_dorfman@HOTMAIL.COM>
Subject:   Re: where also statement
Comments:   To: paszty@XOMA.COM
Content-Type:   text/plain; format=flowed

Nick,

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.

Kind regards, Paul M. Dorfman

Original---- Message Follows---- From: Nick Paszty <paszty@XOMA.COM> Reply-To: Nick Paszty <paszty@XOMA.COM> To: SAS-L@LISTSERV.UGA.EDU Subject: where also statement Date: Thu, 14 Nov 2002 17:00:06 -0800

hello.

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.

data one; set x;

where (var1=2 and var3=4);

run;

data one; set x;

where var1=2; where also var3=4;

run;

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?

thanks,

nick

_________________________________________________________________ The new MSN 8: advanced junk mail protection and 2 months FREE* http://join.msn.com/?page=features/junkmail


Back to: Top of message | Previous page | Main SAS-L page