```Date: Mon, 5 Oct 2009 11:59:25 -0700 Reply-To: kondal Sender: "SAS(r) Discussion" From: kondal Organization: http://groups.google.com Subject: Re: To find the repeating or same set of products in the orders Comments: To: sas-l@uga.edu Content-Type: text/plain; charset=ISO-8859-1 On Oct 5, 10:11 pm, gerhard.hellrie...@T-ONLINE.DE (Gerhard Hellriegel) wrote: > how do your data look like? Please give a example of what you have. > > eg: > > cust_id p1 p2 p3 p4 .... p10 > 1 0 2 0 5 3 > 2 1 5 2 0 0 > 3 0 0 3 0 8 > > for the number of ordered pieces of p1, p2, p3, ... > > or in any other form? > > Gerhard > > On Mon, 5 Oct 2009 09:21:26 -0700, kondal wrote: > >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 > > Sample: 1 1 1 2 1 3 1 4 1 5 1 6 1 7 1 8 2 1 2 4 2 6 2 7 2 8 3 1 3 2 3 4 3 9 Same set of Products (1,4) (1,4,6) (1,4,6,7) ```

Back to: Top of message | Previous page | Main SAS-L page