Date:         Mon, 16 Feb 2009 13:23:51 -0600
Reply-To:     Mary <mlhoward@avalon.net>
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
              Table
Comments: To: brian_newquist@yahoo.com
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.

-Mary

  ----- Original Message ----- 
  From: Brian Newquist 
  To: SAS-L@LISTSERV.UGA.EDU 
  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.

  Thanks,

  Brian