Date: Mon, 16 Feb 2009 13:23:51 -0600
Reply-To: Mary <email@example.com>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: Mary <mlhoward@AVALON.NET>
Subject: Re: Question Concerning Handling Large Many-to-Many Join Output
Content-Type: text/plain; charset="iso-8859-1"
Another consideration is to make sure that you have indexes on the fields that you
are joining on. I'm concerned that you are saying that you will have table1 * table2
rows in your final table- if your inner join is joining on some field, then that would be
unusual. The field that you are joining on should have an index on it.
----- Original Message -----
From: Brian Newquist
Sent: Monday, February 16, 2009 11:51 AM
Subject: Question Concerning Handling Large Many-to-Many Join Output Table
I am trying to join two datasets. My main issue has to do with the size of a table I am trying to produce from a many-to-many join. I am using PROC SQL to do an inner join of a dataset having 7 columns and containing 1,528,062 records with another having the same number of columns and containing 101 records.