Very Computer

by **Lesueur, Jeff, BMG Direct - NY15** » Sat, 05 Aug 2000 04:00:00

is it the case that the cartesian product must always be the
first results dataset in proc sql before the impact of the variable
select and where clauses take effect ?

by **David Johns** » Sat, 05 Aug 2000 04:00:00

Jeff,

Not sure, and my experience of is not necessarily definitive. My SQL guru
colleague has gone, so I can't check with her.

Run your proc SQL with the _tree option set in the options. You'll see the
decision matrix then.

I believe it is an undocumented feature!

Regards

David.

04/08/2000 16:45
___________________________________________________________________________

cc:

Subject: proc sql and cartesian product

"THIS MESSAGE ORIGINATED ON THE INTERNET - Please read the detailed
disclaimer below"

----------------------------------------------------------------------

is it the case that the cartesian product must always be the
first results dataset in proc sql before the impact of the variable
select and where clauses take effect ?

----------------------------------------------------------------------
The following message has been automatically added by the mail gateway
to comply with a Royal & Sun Alliance IT Security requirement:

"As this email arrived via the Internet you should be cautious about
its origin and content. Replies which contain sensitive
information or legal/contractual obligations are particularly
vulnerable. In these cases you should not reply unless you are
authorised to do so, and adequate encryption is employed.

If you have any questions, please speak to your local desktop
support team or IT security contact".
----------------------------------------------------------------------