Date: Mon, 21 Feb 2000 17:32:28 -0500
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
Subject: Processing efficiency
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.
Is there a point where a merge becomes more efficient than a format?