LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous messageNext messagePrevious in topicNext in topicPrevious by same authorNext by same authorPrevious page (October 2009, week 1)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
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)


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