Date:         Mon, 21 Feb 2000 17:32:28 -0500
Reply-To:     DEppler@SARALEE.COM
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         DEppler@SARALEE.COM
Subject:      Processing efficiency
Comments: To: SAS-L@UGA.CC.UGA.EDU
Content-type: text/plain; charset=us-ascii

I have a SAS dataset of historical orders (cust_nbr/ordr_nbr/order-form line
#/style) sorted by cust # & order # with @70 million rows.  I have another SAS
dataset of styles/product category/product category code with @12,000 rows.  I
am creating a report showing the number of combinations of product categories
present within an individual order and then ranking them by most common
occurrence of combinations.

My Question:
Is there a point where a merge becomes more efficient than a format?