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