Very Computer

1. Problem with a Cartesian merge (PROC SQL)

Hi SAS-lers,

I am trying to learn and use PROC SQL more - - this is the code I wrote
this morning...I was trying to get a complete Cartesian merge between
two data sets.

Data_Set1 had 47K records
Data_Set2 had 180K records

The resulting data set only had 50K records - I was expecting 180K+...so
either I still don't understand Cartesian merges, or I wrote the SQL
poorly.  Could anyone let me know where I am messing up????

TIA everyone!

Dave

Example:

PROC SQL ;
        CREATE table WORK.Merge AS SELECT
                Data_Set1.eFullNam
                , Data_Set1.eSiteNum
                , Data_Set1.eSiteNam
                , Data_Set1.eInsCo
                , Data_Set2.eMembNam
                , Data_Set2.eMembDOB
                , Data_Set2.eGender
                , Data_Set2.eMemb_SS
                , Data_Set2.MembNum
        FROM WORK.Data_Set1, WORK.Data_Set2
        WHERE Data_Set1.MembNum = Data_Set2.MembNum
        ;
QUIT ;

--
Posted via Mailgate.ORG Server - http://www.Mailgate.ORG

2. hey

3. proc sql and cartesian product

4. search tech. data about SGI monitor

5. memory merge vs disc merge

6. MS Winsock2 update

7. Cartesian Products Web Site

8. DOS 6 "move" = delete!

9. Representing unions of Cartesian products

10. cartesian product

11. Interview Question cartesian product w/SET

12. Cartesian product

13. optimal partition into cartesian products?