Date:         Thu, 22 Jun 2006 07:59:51 -0700
Reply-To:     Irin later <irinfigvam@YAHOO.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Irin later <irinfigvam@YAHOO.COM>
Subject:      Re: My query involves Cartesian product
Comments: To: monal kohli <k_monal_99@yahoo.com>
In-Reply-To:  <20060622144753.59096.qmail@web54212.mail.yahoo.com>
Content-Type: text/plain; charset=iso-8859-1

Mona,

  Does it mean that it is not necessarily my query mistake? I am just wondering if I should cancel my job as my query is currently running against  Data warehouse?

  Thank you!

  Irin

monal kohli <k_monal_99@yahoo.com> wrote:
  If I understand this,you are using PROC SQL where you
are referring to 4 datasets.When you use proc sql
where you are trying to join two (or more) tables sas
creates a cartesian product and then applies the join
conditiion to filter records.

HTH
Mona

--- Irin later wrote:

> Hello,
>
> I run the following query and got a note that my
> query involves Cartesian product. Why?
> What I am doing wrong?
>
> Thank you in advance,
>
> Irin
>
>
***********************************************************
>
> PROC SQL;
> 25 !
> 26 CREATE TABLE OUT.MEDICAL_IR AS
> 27 SELECT T2.MEMBER,
> 28 SUM(T1.ALLOW_AMT) AS ALLOW_AMT
> 29 FROM DW.V_MEDSRV_PHASRV_FCT
> AS T1,
> 30 DW.V_ETG_MED_CLAIMS
> AS T2,
> 31 DW.V_STD_TOS_CATEGORY
> AS T3,
> 32 j.member_demo
> AS T4
> 33 WHERE T2.MEMBER=T4.MEMBER
> 34 AND T1.TOS_CAT_KEY = T3.TOS_CAT_KEY
> 35 AND T1.MEDSRV_KEY = T2.MEDSRV_KEY
> 36 AND T2.ETG_PERIOD = 200512
> 37 AND T1.MEDSRV_KEY ^= 0
> 38 AND T4.RISK="INS"
> 3 The SAS System
>
>
>
> 10:20 Thursday, June 22, 2006
>
> 39 GROUP BY T2.MEMBER;
> NOTE: The execution of this query involves
> performing one or more Cartesian product joins that
> can not be optimized.
>
>
> ---------------------------------
> Do you Yahoo!?
> Everyone is raving about the all-new Yahoo! Mail
> Beta.
>


__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com



---------------------------------
Want to be your own boss? Learn how on  Yahoo! Small Business.