|
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.
| 
