Date:         Mon, 5 Oct 2009 11:59:25 -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:      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 <kondal...@GMAIL.COM> 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)