Date:         Fri, 31 Jul 1998 11:51:56 -0400
Reply-To:     HERMANS1 <HERMANS1@WESTAT.COM>
Sender:       "SAS(r) Discussion" <SAS-L@UGA.CC.UGA.EDU>
From:         HERMANS1 <HERMANS1@WESTAT.COM>
Subject:      Re: Many-to-Many Merge
Comments: To: Lau Anna <ylau1@UMBC.EDU>
Content-Type: text/plain; charset=US-ASCII

SAS does.  An unrestricted R<<->>R merge (or join) produces a
Cartesian product.  The dataset it produces contains a number of rows
or obs equal to the number of rows in the first dataset times the
number of rows in the second dataset.  A merge restricted to groups
produces a dataset with a number of rows equal to the sum of all
group1 rows times group2 rows.  In either case, these merges often
produce either great volumes of data or misleading results, or both.
Sig
______________________________ Reply Separator _________________________________
Subject: Many-to-Many Merge
Author:  Lau Anna <ylau1@UMBC.EDU> at Internet-E-Mail
Date:    7/31/98 12:10 AM
 
 
Hi, I need to merge two tables together and it's a many-to-many merge.
Does anyone know if SAS support this kind of merge? Thanks for any information.
--
                                                                ANNA