Date: Mon, 5 Oct 2009 09:21:26 -0700
Reply-To: kondal <kondal717@GMAIL.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: kondal <kondal717@GMAIL.COM>
Organization: http://groups.google.com
Subject: To find the repeating or same set of products in the orders
Content-Type: text/plain; charset=ISO-8859-1
Dear Friends
To find the repeating or same set of products in the orders. or the
repeating patterns or groups of the same orders made by the customers.
Example:
first customer ordered products are 1,2,3,4,5,6,7,8,9,10
second customer ordered products are products 1,4,6,7,8
third customer ordered products are products 1,2,4,6,9
fourth customer ordered products are products 1,2,3,4,5,
fifth customer ordered products are products 6,7,8,9
Like 2500 customers are ordered different Products.
Now I would like to know 2 or more same set or Cluster or group of
products ordered;
if it is 2 products then , products (1, 4)
if its more than 2 , products (1,4,6) is one group or cluster of
products which are ordered together for so many times and like wise
products (6,7,8,9) is one group , products (1,2,3,4,5) is one group ,
products ( 1,2,4) is one cluster, like wise........
Help me in code
|